Cool formula, Frank. The OP would need it to be
=LOOKUP(2,1/(2:2<""),1:1)
Bernie
MS Excel MVP
"Frank Kabel" wrote in message
...
Hi
as alternative:
=LOOKUP(2,1/(1:1<""),1:1)
Also see http://www.xldynamic.com/source/xld.LastValue.html
--
Regards
Frank Kabel
Frankfurt, Germany
"sd" schrieb im Newsbeitrag
...
I have columns of data starting from Jan 2002 thru Sep 04 (33
columns)
Data contains numbers or are blank
Is there any formula (other than a VBA) that can determine against
each row
the last month I had any number
Example:-
Jan-00 feb-00 mar-00 apr-00 may-00
50 12
The result should be Feb-00 as that month is the last time when I
had a
data (and not blank) looking from right to left.
Just the formula to determine the column # will suffice, using offset
I can
determine the month.