Macos – How to reference the last filled in cell in of a column in Apple’s Numbers app (OS X)

apple-numbersmacos

I need the footer of a table in Numbers to calculate the difference between the first value in a column and the last value in a column. The last value may be greater, or smaller than the first. How do I reference the last filled in value of a column?

Best Solution

If you don't have empty cells between the first and last entry, the last entry can be found using COUNT, and retrieved using OFFSET. Example :

=OFFSET(A$1, COUNT(A)-1, 0)

the difference between the first and last would then be something like:

=OFFSET(A$1, COUNT(A)-1, 0) - A$1

Related Question