MECTILE

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

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)

Related posts:

  1. Get the number of days in a year in Excel
  2. Excel VBA – Can’t find library or project.
  3. RSS feed aggregator/combiner in PHP
  4. Unlock the Nokia 6300 for under $10 with the iSIM

Posted

in

by

MECTILE

Tags:

, , ,

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *