Take a look at

http://www.mcgimpsey.com/excel/randomint.html

You can use the RandInt function found there. Assume your names were in
column A. Select, say, B1:B20 and array-enter (CTRL-SHIFT-ENTER or
CMD-RETURN):

=INDEX(A:A,RandInt(1,COUNTA(A:A)))


In article <892A6F97-A323-447B-A79A-CA1ECD595D2D@microsoft.com>,
yorkshire exile <yorkshire exile@discussions.microsoft.com> wrote:

> I need to be able to choose 20 names at random from an existing database of
> over 1000 names