Posts Tagged ‘function’

In Excel, find the value on the last row as a function, not VBA

Monday, July 20th, 2009

Here is a quick post, how to find the value of the last cell in a column.

Exaample below uses Column A with the first 3 rows used for the header:

=INDEX(A:A,COUNT(A:A)+3)