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


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 ?



RE: Picking random Cells/numbers

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


...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:


Have fun!


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.