help with random numbers
 

I have a spreadsheet that has a column with 10 cells. Each cell will have
its own number in it, but I want them to be randomly generated from 0-9. I
need all cells to have a unique number in it. any help with this would be
appreciated. Thanks

help with random numbers
 

in the adjacent column to your numbers put in the formula

=rand()

then drag fill down

Now sort both columns with this column with the formula as the key formula.
This will randomize your numbers.

--
Regards,
Tom Ogilvy

"justaguyfromky" wrote in message
...
I have a spreadsheet that has a column with 10 cells. Each cell will have
its own number in it, but I want them to be randomly generated from 0-9.
I
need all cells to have a unique number in it. any help with this would be
appreciated. Thanks

help with random numbers
 

I suggest to take my function UniqRandInt().

Press ALT + F11, insert a module, copy my function UniqRandInt() from
http://www.sulprobil.com/html/uniqrandint.html, go back to spreadsheet,
select your 10 cells, enter =UniqRandInt(10), finish entry with CTRL + SHIFT
+ ENTER.

HTH, Bernd