View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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