random

  • Thread starter Thread starter ADK
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RANDOM NUMBER GENERATION. 4
can I use information from another sheet modify it, into a formula 3
Random Name Generator 5
RANDBETWEEN() 9
random number generator 6
display a value from Sheet1-A1:A10 in Sheet2-B1 2
random letter generation 5
Generate random numberes using reference to the other cell. 7

Back
Top