random
 

I have cells A1 through A10 with player names (John, Joan, Tom, etc.)

I would like to generate 5 teams by random. How can I do this with excel?
....without repeating names

Thanks

random
 

ADK,

Put the formula

=RAND()

into cells B1:B10, select A1:B10, sort based on column B (either ascending or descending) then take
the names two at a time to make your random teams.

HTH,
Bernie
MS Excel MVP


"ADK" wrote in message ...
I have cells A1 through A10 with player names (John, Joan, Tom, etc.)

I would like to generate 5 teams by random. How can I do this with excel? ...without repeating
names

Thanks