Create the formula...
=int(rand()*100000)
Copy the formula down 49 rows then using Copy and Paste Special make the
formulas into values.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"Lee Mathew" wrote:


Hi,

I would like to make a sample of 50 non-consecutive numbers. But
everytime i do a sample, i get duplicate numbers. Could you please tell
me a way where I could make a sample without duplicate numbers.

Thank you.




--
Lee Mathew