Excel - Formulas and Functions for a Dummy - Amature Hour

%3CLINGO-SUB%20id%3D%22lingo-sub-1546961%22%20slang%3D%22en-US%22%3EExcel%20-%20Formulas%20and%20Functions%20for%20a%20Dummy%20-%20Amature%20Hour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546961%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%2C%3C%2FP%3E%3CP%3ESo%20really%20my%20brain%20does%20not%20do%20so%20well%20with%20numbers%20and%20mathematical%20lingo.%26nbsp%3B%20I%20have%20been%20trying%20to%20learn%20today%20about%20functions%20and%20formulas.%20My%20experience%20with%20Excel%20is%20based%20more%20around%20checklists%2C%20forms%20and%20my%20own%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20very%20much%20so%20a%20beginner%20with%20that%20regard%20to%20formulas%2Ffunctions%20and%20data%20transferring.%26nbsp%3B%20My%20brain%20does%20not%20function%20at%20its%20finest%20when%20tying%20to%20interpret%20numbers%20and%20mathematical%20lingo%20into%20my%20checklist%20and%20trying%20to%20figure%20out%20how%20to%20successfully%20create%20a%20permutation%20and%20connect%20that%20data%20from%20one%20worksheet%20to%20another.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20of%20any%20fool%20proof%20and%20or%20really%20easy%20to%20follow%20tutorials%20in%20these%20areas%20that%20might%20be%20able%20to%20help%3F%26nbsp%3B%20Any%20and%20all%20information%20is%20much%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1546961%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHelp%20Request%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1547436%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Formulas%20and%20Functions%20for%20a%20Dummy%20-%20Amature%20Hour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547436%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740460%22%20target%3D%22_blank%22%3E%40JedHopkins%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20this%20link%20is%20a%20start%20for%20you%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F41053936%2Fgenerate-all-permutation-of-multiple-lists-in-excel%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F41053936%2Fgenerate-all-permutation-of-multiple-lists-in-excel%3C%2FA%3E.%20They%20even%20mention%20a%20VBA%20macro.%20And%20this%20one%20(%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Df7mMUoB1VLI%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Df7mMUoB1VLI%3C%2FA%3E)%20is%20a%20little%20older%20but%20maybe%20also%20helpful.%3C%2FP%3E%3CP%3EGood%20luck%3C%2FP%3E%3CP%3ECheers%3CBR%20%2F%3ERolf%3CBR%20%2F%3E%3CBR%20%2F%3E%23MCT%20%23LearnWithRolf%20%23TheCloud42%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1557095%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Formulas%20and%20Functions%20for%20a%20Dummy%20-%20Amature%20Hour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1557095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740460%22%20target%3D%22_blank%22%3E%40JedHopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%20the%20reply%20you%20have%2C%20you%20may%20want%20to%20think%20about%20looking%20into%20Power%20Query%20(Get%20%26amp%3B%20Transform)%20on%20the%20Excel%20Data%20tab.%26nbsp%3B%20Here%20is%20a%20link%20for%20an%20easy%20to%20follow%20tutorial%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.howtoexcel.org%2Fpower-query%2Fall-possible-combinations-of-items-from-two-lists%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.howtoexcel.org%2Fpower-query%2Fall-possible-combinations-of-items-from-two-lists%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi Community,

So really my brain does not do so well with numbers and mathematical lingo.  I have been trying to learn today about functions and formulas. My experience with Excel is based more around checklists, forms and my own database.

 

I am very much so a beginner with that regard to formulas/functions and data transferring.  My brain does not function at its finest when tying to interpret numbers and mathematical lingo into my checklist and trying to figure out how to successfully create a permutation and connect that data from one worksheet to another.

 

Does anyone know of any fool proof and or really easy to follow tutorials in these areas that might be able to help?  Any and all information is much appreciated!

 

2 Replies

Hello @JedHopkins

 

Maybe this link is a start for you: https://stackoverflow.com/questions/41053936/generate-all-permutation-of-multiple-lists-in-excel. They even mention a VBA macro. And this one (https://www.youtube.com/watch?v=f7mMUoB1VLI) is a little older but maybe also helpful.

Good luck

Cheers
Rolf
#MCT #LearnWithRolf #TheCloud42 

 

This video explains how to calculate combinations and permutations using the COMBIN and PERMUT functions in Microsoft Excel. The step-by-step calculations ar...

@JedHopkins 

 

In addition to the reply you have, you may want to think about looking into Power Query (Get & Transform) on the Excel Data tab.  Here is a link for an easy to follow tutorial: https://www.howtoexcel.org/power-query/all-possible-combinations-of-items-from-two-lists/