Cell number replacement

[red]

I need to put a formla into a cell so that it chooses the last entry in a
column. I have doe this once before but can't remember whats required.
I need to say =A? where ? is "count A3:A300" so the answer in the formula
point to ,say, A25 if thats the last entry in the column.

 

[Mike H]

Hi,

If its a numeric value try this

=LOOKUP(10^23,A1:A300)

or if it could be text
=INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A300))*(A1:A300<>""))))

Mike

 

[red]

Thanks Mike, both worked a treat!

Hi,

If its a numeric value try this

=LOOKUP(10^23,A1:A300)

or if it could be text
=INDIRECT("A"&SUMPRODUCT(MAX((ROW(A1:A300))*(A1:A300<>""))))

Mike

 

[Mike H]

Glad I could help

Thanks Mike, both worked a treat!