Assign numbers (say in Column A) from 1 to 200 to the people on your list
Enter the following in any column
=ROUNDUP(A1*200,0) and copy down to A20

You can use the numbers generated to pick up 20 names at random
You can enter =VLOOKUP(B1,A:A,1,False) in C1 and copy to C20 to get names in
Column C...


"ziggi456" wrote:

Hi
I have a list of people (approx 200) and need daily to pick 20% of these
people on a random search