| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random Values
It is late and I should go to sleep, hope I get it right this time;
1. Insert Column A and enter numbers from 1 to 200 2. Have names in Column B 3. In C1 enter =ROUNDUP(RAND()*200,0) and copy down to C20 4. in D1 enter =VLookup (C1,A:B,2,False) and copy down to D20 Press F9 whenever you need a new set of 20 random names... "Sheeloo" wrote: Sorry VLOOKUP should be entered in D1 and copied to D20 =VLookup (C1,A:B,2,False) assuming you have entered the RAND() formula in C1 and your Serial Numbers are in Col A and Names in Col B... "ziggi456" wrote: Hi I have a list of people (approx 200) and need daily to pick 20% of these people on a random search |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array? Put values from random columns into 4 | Excel Worksheet Functions | |||
| Function to select random values from a list. | Excel Worksheet Functions | |||
| Need to generate random values from a list | Excel Discussion (Misc queries) | |||
| Random Values totaling Cell value | Excel Discussion (Misc queries) | |||
| Generate random numbers between two values and with a given mean | Excel Worksheet Functions | |||
Threaded Mode
