Random help please

[Terry]

Hi

I wish to use my ipaq (Excel mobile) for creating random numbers for a bingo
game on a coach trip, instead of a cumbersome set of discs/balls etc.
Numbers 1 to 90.(without number duplication)
Easiest way for me to achieve please.
I have Excel 2003 on my desktop to simulate functions if needed.

TIA

Terry

 

[Mike H]

Terry,

One way. Put the numbers 1 to 90 in column A of your worksheets. In column B
enter the formula
=Rand()
and drag down to the same length as column A.

Select column A & B and sort by column B and the numbers in column A will be
unique and in random order. Recalculate and re-sort for the next game.

Mike

 

[Pete_UK]

Fill the numbers 1-90 down column A, then put this formula in B1:

=RAND()

and fill this down. Then just sort both columns using column B as the
sort field. Call out the numbers from column A in the order that they
appear.

For a new game, just re-sort A and B, as the random numbers will have
changed.

Hope this helps.

Pete

 

[Terry]

Thank you Mike & Pete...will put to test.

Regards

Terry
Fill the numbers 1-90 down column A, then put this formula in B1:

=RAND()

and fill this down. Then just sort both columns using column B as the
sort field. Call out the numbers from column A in the order that they
appear.

For a new game, just re-sort A and B, as the random numbers will have
changed.

Hope this helps.

Pete

 

[Pete_UK]

Mike and I gave you virtually identical answers, so it should work.

Pete