'Excel formulas. 'Last filled cell in column A, confirm with Ctrl-Shift-Enter: =INDEX(A:A,MAX((A:A>"")*(ROW(A:A)))) 'Row number of last filled cell in column A, confirm with just Enter: =INDEX(MAX((A:A>"")*(ROW(A:A))),1)