| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Random Selection
How do I randomly select say 6 names from an 18 word list from excel?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Random Selection
Put the names in a column (say from A1 thru A18) in B1 thru B18 enter:
=RAND() Sort the data by column B. This shuffles the names in column A. Just pick the top six. To get another sample just re-sort and pick the top six again. -- Gary's Student "Cookie" wrote: How do I randomly select say 6 names from an 18 word list from excel? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Random Selection
Take a look he
http://mcgimpsey.com/excel/udfs/samplenoreplace.html In article , Cookie wrote: How do I randomly select say 6 names from an 18 word list from excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Random question / data selection | Excel Worksheet Functions | |||
| Random Selection | Excel Worksheet Functions | |||
| Random Selection of items in Excel? | Excel Discussion (Misc queries) | |||
| random selection from a range of cells | Excel Worksheet Functions | |||
Hybrid Mode
