Finding the last non-blank entry in an array

  • Thread starter Thread starter Cornelius
  • Start date Start date
C

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
 
=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
 
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




.
Click to expand...
 
Back
Top