How can I fill a block of 300 cells with non-repeating random #s
 

Using Excel 2003, I've tried RAND and RANDBETWEEN functions but numbers
generated appear to be random to 3 decimal places (even with the cell
formatted for no decimals) and therefore, with 1000 possible outcomes for
each calculation, I end up with numerous, repeated "random" integers in the
block of cells.

This is for a charity fundraiser and I don't wish to fill the cells by
throwing darts, so any help will be greatly appreciated.

How can I fill a block of 300 cells with non-repeating random #s
 

Simplest way is to enter your number series down a column.
In the adjoining column, enter the Rand function:
=Rand()
and *double* click the fill handle to automatically fill the formula down to
match the original column.

Then, select both columns and sort on the Rand() column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"nerkaman" wrote in message
...
Using Excel 2003, I've tried RAND and RANDBETWEEN functions but numbers
generated appear to be random to 3 decimal places (even with the cell
formatted for no decimals) and therefore, with 1000 possible outcomes for
each calculation, I end up with numerous, repeated "random" integers in
the
block of cells.

This is for a charity fundraiser and I don't wish to fill the cells by
throwing darts, so any help will be greatly appreciated.