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