I have the following formula in Excel (not vba):
=RANDBETWEEN(1,10)
Then I auto fill down 10 rows. How can I rewrite the formula so the numbers don't repeat.
I have the following formula in Excel (not vba):
Then I auto fill down 10 rows. How can I rewrite the formula so the numbers don't repeat. 

migrated from stackoverflow.com Apr 30 '11 at 11:50This question came from our site for professional and enthusiast programmers. 


There is a an easy way to do this with two columns. In A1, enter
and fill down to A10. In the adjacent column, enter
and fill down. There is a negligible chance that of the 10 random floating point decimals (15 digits accuracy, I think), any two numbers will be the same. Thus, 


This previous answer does something similar: see how But it requires using VBA. I don't know if you want that or if you insist on using worksheet formulas only. 

