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
|