How do I create a formula that picks the last entry

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

How do I create a formula that picks the last entry in a column of numbers?

Ex. I have 12 Rows labeled January thru December. I want the formula to
enter the last entry I made in Row 13. So if the last entry was in October,
Row 13 would enter October or Row 10 data.

Thanks in advance

Dave K
 
Dave

=ADDRESS(MATCH(9.99999999999999E+307,A:A),1
to return the address of last numeric cell in column A

=LOOKUP(9.99999999999999E+307,A:A)
to return the last numeric value in Column A

And just for helluvit....

=LOOKUP(REPT("z",255),A:A)
to return the last non-numeric value in Column A

=ADDRESS(MATCH(REPT("z",255),A:A),1)
to return the address of last non-numeric cell in column A

Gord Dibben XL2002
 
Thank both of you for your help!

Dave K

Gord Dibben said:
Dave

=ADDRESS(MATCH(9.99999999999999E+307,A:A),1
to return the address of last numeric cell in column A

=LOOKUP(9.99999999999999E+307,A:A)
to return the last numeric value in Column A

And just for helluvit....

=LOOKUP(REPT("z",255),A:A)
to return the last non-numeric value in Column A

=ADDRESS(MATCH(REPT("z",255),A:A),1)
to return the address of last non-numeric cell in column A

Gord Dibben XL2002
Click to expand...
 
Back
Top