Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating number from groups of numbers
If someone could help me with this I would really appreciate it.
If you have three sets of numbers. Say in Column A you have 1 2 & 3 in Column B you have 4 5 & 6 and then in Column C you have 7 8 & 9. Is there any way to see all the variations of numbers you could come up with if you used one number from each Column. For example starting with the number 1 in Column A you could end up with 9 different numbers, see example below. Also, they have to be in order, so Column A number always has to be in first place, Column B in second place and Column C in Third. The data set I am using is much larger which is why I'm looking for a way to handle this. Any help will be appreciated. Thanks. 147 148 149 157 158 159 167 168 169 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Non updatable Unique Random Number | Excel Worksheet Functions | |||
Is this possible ??? | Excel Discussion (Misc queries) | |||
Assign number to groups of same numbers | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions |