I frequently copy Formulas from one months data to the next, but I run into trouble when I want to get a total off the last row, when the last row is different each month. I discovered a Formula that will read the last value (before blanks) in a range.
Related Articles
- Enter the formula =INDEX($E$1:$E$5100,LARGE(IF($E$1:$E$5100<>"",ROW($E$1:$E$5100)),1),1)
- Press Ctrl-Shft-Enter