I have the following formula in Excel (not vba):
Then I auto fill down 10 rows. How can I re-write the formula so the numbers don't repeat.
migrated from stackoverflow.com Apr 30 '11 at 11:50
This 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.