Get the last value in an Excel Range
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.
- 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