random

A

ADK

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
 
B

Bernie Deitrick

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
 
Top