Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
All Possible Number Combinations
I have the following numbers: 0, 1, 2, 3, 4
Looking for a formula that lists all possible four digit combinations for the above five digits. i.e. 0001 0002 Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
All Possible Number Combinations
Kate,
Yoe need to explain more clearly. You number set is 0,1,2,3,4 and you give an examples of 0001 which uses the zero 3 times. Do you really mean this? If so is 0000 a valid combination and if not why not? what are the rules? Mike "Kate" wrote: I have the following numbers: 0, 1, 2, 3, 4 Looking for a formula that lists all possible four digit combinations for the above five digits. i.e. 0001 0002 Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
All Possible Number Combinations
Yes, 0000 would be a valid combination.
"Mike H" wrote: Kate, Yoe need to explain more clearly. You number set is 0,1,2,3,4 and you give an examples of 0001 which uses the zero 3 times. Do you really mean this? If so is 0000 a valid combination and if not why not? what are the rules? Mike "Kate" wrote: I have the following numbers: 0, 1, 2, 3, 4 Looking for a formula that lists all possible four digit combinations for the above five digits. i.e. 0001 0002 Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
All Possible Number Combinations
Hi,
In which case use the code below to produce the 303600 permutations http://www.ozgrid.com/forum/showthread.php?t=22673 Mike "Kate" wrote: Yes, 0000 would be a valid combination. "Mike H" wrote: Kate, Yoe need to explain more clearly. You number set is 0,1,2,3,4 and you give an examples of 0001 which uses the zero 3 times. Do you really mean this? If so is 0000 a valid combination and if not why not? what are the rules? Mike "Kate" wrote: I have the following numbers: 0, 1, 2, 3, 4 Looking for a formula that lists all possible four digit combinations for the above five digits. i.e. 0001 0002 Thank you. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
All Possible Number Combinations
=MOD(INT((ROW(A1)-1)/125),5)&MOD(INT((ROW(A1)-1)/25),5)&MOD(INT((ROW(A1)-1)/5),5)&MOD(ROW(A1)-1,5)
and copy down your 625 rows. -- David Biddulph "Kate" wrote in message ... Yes, 0000 would be a valid combination. "Mike H" wrote: Kate, Yoe need to explain more clearly. You number set is 0,1,2,3,4 and you give an examples of 0001 which uses the zero 3 times. Do you really mean this? If so is 0000 a valid combination and if not why not? what are the rules? Mike "Kate" wrote: I have the following numbers: 0, 1, 2, 3, 4 Looking for a formula that lists all possible four digit combinations for the above five digits. i.e. 0001 0002 Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting number combinations | Excel Discussion (Misc queries) | |||
Number combinations | Excel Worksheet Functions | |||
Sum of all combinations | Excel Discussion (Misc queries) | |||
find all combinations of cells that add up to certain number | Excel Worksheet Functions | |||
find all combinations of cells that add up to certain number | Excel Discussion (Misc queries) |