Cell number replacement

R

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.
 
M

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
 
R

red

Thanks Mike, both worked a treat!

Mike H said:
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
Click to expand...
 
Top