one way is put an index 1 to 1000 in the previous column to the names
column . and then in some other column choose 20 random numbers between 1
and 1000 and choose the name correponding to these random numbers by using
vlookup function.






yorkshire exile <yorkshire wrote in message
...
I need to be able to choose 20 names at random from an existing database
of
over 1000 names