How do I create a formula that picks the last entry

[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

 

[xlbo]

for data incolumn E, this would work
=INDEX(E1:E12,COUNTA(E1:E12))

 

[Dave]

That did it!

Thanks

 

[Gord Dibben]

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

 

[Dave]

Thank both of you for your help!

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