picking random cellsnumbers

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Picking random Cells/numbers

Picking random Cells/numbers

resolvedResolved · Low Priority · Version 2007

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

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.


 

Excel tip:

Working with 3D formulas

You can only use fill-down if you remove $ for Absolute References.

View all Excel hints and tips


Server loaded in 0.07 secs.