| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I randomly select data elements from a table?
I have a list of 100 golfers. I wish to randomly select them into pairs for
an upcoming 4 ball competition. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I randomly select data elements from a table?
Say your data is in A1:A100
You could put =rand() in B1:b100 Sort columns A:B by column B. Then move A51:A100 to B1:B50 And delete the stuff in B51:B100 Ken Bowditch wrote: I have a list of 100 golfers. I wish to randomly select them into pairs for an upcoming 4 ball competition. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i randomly select 780 rows from 4000 rows of data | Excel Worksheet Functions | |||
| Restricting Data Elements in Pivot Table | Excel Worksheet Functions | |||
| how to randomly select data in excel | Excel Worksheet Functions | |||
| how to randomly select data in excel | Excel Worksheet Functions | |||
| how to randomly select a name in a list and then the select the ne | Excel Worksheet Functions | |||
Linear Mode
