Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I would like to generate unique random numbers from say 34 numbers, and starting in "B2" list them in 5 number combinations going down until ALL the 34 numbers have been used. I know in this example the first 6 combinations will have 5 numbers and the 7th combination will have only 4. There may be occassions where there might be more or less numbers than 34 numbers and maybe 4,5,6 or 7 number combinations so code where I could adapt it accordingly will be much appreciated. Thanks in advance, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unique Random Numbers | Excel Discussion (Misc queries) | |||
Unique RANDOM NUMBERS within specified range | Excel Worksheet Functions | |||
Unique Random Numbers | Excel Programming | |||
generate unique random numbers | New Users to Excel | |||
unique random numbers | Excel Programming |