Picking random Cells/numbers

Resolved · Low Priority · Version 2007

Tue 22 May 2012, 16:42 Delegate Danny said...

Danny has attended:
Excel Intermediate course

Picking random Cells/numbers

Hi,

We need to pick 2 5-aside football teams at our office.

if we assign each player a number from 1-10, is there a function that will randomly pick 5 numbers ?

Thanks,

Danny

Tue 22 May 2012, 21:36 Trainer Anthony said...

RE: Picking random Cells/numbers

Hi Danny. Thanks for your query. Try entering...

=RANDBETWEEN(1,10)

...into a cell and see what happens. If you autofill down, however, you'll note you don't end up with a list of unique, random numbers. Creating one of those is...interesting:

http://www.get-digital-help.com/2009/07/03/how-to-create-a-random-list-of-unique-numbers-in-excel/

Have fun!

Anthony

Tue 29 May 2012: Automatically marked as resolved.

Training courses