Finding the last non-blank entry in an array

[Cornelius]

Hi all. I have a table of values that increases every
week, and a separate table on another sheet that reads the
last three weeks' worth of values form that table. rather
than manually changing the columns every day, is there a
way to determine where the blanks begin and then retur the
values to the right of that?

Thanks,
ccc

 

[Peo Sjoblom]

=OFFSET($A$1,COUNTA(A:A)-1,1)

will find the last value in A and return the value adjacent to the right

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Guest]

Thanks a lot!

-----Original Message-----
=OFFSET($A$1,COUNTA(A:A)-1,1)

will find the last value in A and return the value adjacent to the right

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom




.