picking random cellsnumbers

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

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

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

# Picking random Cells/numbers

Resolved · 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.

Training courses

Training information:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Working with 3D formulas

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

View all Excel hints and tips