Frank,

I found your solution when I had the same problem of needing the formula to
only select the last non-blank entry. I am curious however in the "OFFSET"
solution which did not work for me (probably because I entered it
incorrectly, since the VLOOKUP did, thanks). The COUNTA(A:A) reference is
likely for the range in question, but what does the $A$1 refer to?

Thanks,
Kem

"Frank Kabel" wrote:

Hi
if you have no blank lines in between use:
=OFFSET($A$1,COUNTA(A:A)-1,0)

If you could have blank rows in between try:
=LOOKUP(2,1/(A1:A1000<""),A1:A1000)

-----Original Message-----
Hi,
I have a spreadsheet that has 52 rows in a particular
column, one row
for each week of the year. As the year progresses the
column fills up
with data but in the 53rd row of that column I want see
the value of
the last cell in that column that is not blank. Can
anyone assist
please?
Many thanks
ArtySin
.