help with sorting

  • Thread starter Thread starter dano63
  • Start date Start date
D

dano63

I am trying to put a golf scramble together. I am going to assign one
player to every team and want to sort the remaining players randomly t
each team. I would like to have four players per team. Can I do thi
with excel?

Thanks,
Dan
 
list the other players in a column (assume column A)

In column B put in the formula

=Rand()

then drag fill down the column next to you names.

Select the filled cells in columns A and B, then do Data=>Sort and sort on
column B.

This will scramble you list of names.

Now pick them 3 at a time coming down the list and assign to the next team.
 
Back
Top