identifying last entry in a column
Posted by Drew on July 11, 2000 10:38 AM
What formula would you use to identify the last entry in a column where very other row is blank? For example:
A1 12
A2
A3 14
A4
A5 8
In this case, I'd like a formula to display 8 at the top of the workbook. This is for a checkbook where it will always show the current balance at the top. I could put a formula in place of the blank data to make it easier.
I tried =INDEX(A7:A100,COUNTA(A1:A100),1) but returns 0 since there are no entries after A5.
Any ideas? Thanx! Drew