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

N

nerkaman

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.
 
R

Ragdyer

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.
 
T

TS2

1. I selected A1 to enter the formula.
2. In the Formula Bar type @sum(RAND())*10000.
3. Highlight and drag that formula to as many cells as you desire to populate.
4. You will generate random numbers. I used Conditional Formatting to check
for duplicate numbers and I removed all decimals.



Here is what that does for you. It will g
 
Top