Picking from a list randomly

[Anthony Slater]

I have a list of 60 names that are in surname order. Many
surnames are the same (ie Smith Brian, Smith Alan, Brown
John, Brown Peter etc..)

How can I randomly choose from the list, 6 groups of 10
people but making sure there are no duplicates in each
group?

Thanks in Advance

 

[Frank Kabel]

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/random.htm

to create unique random numbers (for example in a helper
column) and then sort your data with this helper column to
structure your groups