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

Picking random Cells/numbers

ResolvedVersion 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

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Picking random Cells/numbers

Picking random Cells/numbers

RE: Picking random Cells/numbers

Excel articles

Excel tip:

Sum Up All the Values in A Column