| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique random numbers from list
I would like to create a function that would put 5 random numbers from
a list. The list is in cells A5:A105 and the five random selections can go in B5:B9. I'm using the formula: =INDEX(A:A,RAND()*COUNTA(A:A)) This formula does work most of the time but does not guarantee that the five random selections are unique. Any ideas on how this can be done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique RANDOM NUMBERS within specified range | Excel Worksheet Functions | |||
| how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
| how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
| generate unique random numbers | New Users to Excel | |||
| Random list (1-45) without repeating numbers? | Excel Worksheet Functions | |||
Threaded Mode
