Excel - Formulas and Functions for a Dummy - Amature Hour

Question

Hi Community,So really my brain does not do so well with numbers and mathematical lingo.&nbsp; 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.&nbsp;I am very much so a beginner with that regard to formulas/functions and data transferring.&nbsp; 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.&nbsp;Does anyone know of any fool proof and or really easy to follow tutorials in these areas that might be able to help?&nbsp; Any and all information is much appreciated!&nbsp;

scott rogerson · Answer

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

rolf-42 · Answer

Hello&nbsp;JedHopkins&nbsp;Maybe this link is a start for you:&nbsp;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 luckCheersRolf#MCT #LearnWithRolf #TheCloud42&nbsp;&nbsp;

Forum Discussion

Excel - Formulas and Functions for a Dummy - Amature Hour

Share

Resources