generate whole differnt random numbers across cases or rows

[Guest]

I want to generate whole random numbers down a column. When I use rand()*
method I recieve multiple values of the genererated numbers down the columns
or cases. How can I do this without repeating the number, or so that every
number is unique?

 

[Dave Peterson]

I like J.E. McGimpsey's UDF.

You can find it here:

http://www.mcgimpsey.com/excel/udfs/randint.html