Random help please
 

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

Random help please
 

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

"Terry" wrote:

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

Random help please
 

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

On Sep 4, 9:51*am, "Terry" wrote:
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

Random help please
 

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

Regards

Terry
"Pete_UK" wrote in message
...
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

On Sep 4, 9:51 am, "Terry" wrote:
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

Random help please
 

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

Pete

On Sep 4, 11:29*am, "Terry" wrote:
Thank you Mike & Pete...will put to test.