Answered by:
How can I copy a formula down the entire length of my data...30,000+ rows
Question

Answers

If you turn the data into a table before you put the formula into the topmost cell, when you add the formula, it's automagically copied down for you.
The double click the bottom right corner thing works too as long as the column to the right is continuous down to the last row of data; if there are any breaks, the copy will stop at the first blank cell. Try it on a small set of data to see how it works.
 Marked as answer by ITBobbyP Monday, March 16, 2015 6:49 PM
All replies


If you turn the data into a table before you put the formula into the topmost cell, when you add the formula, it's automagically copied down for you.
The double click the bottom right corner thing works too as long as the column to the right is continuous down to the last row of data; if there are any breaks, the copy will stop at the first blank cell. Try it on a small set of data to see how it works.
 Marked as answer by ITBobbyP Monday, March 16, 2015 6:49 PM
