Hi
to find the last non-blank value
=INDEX(A2:G2,MATCH(9.99999999999999E+307,A2:G2))
to find the last non-zero value
=LOOKUP(2,1/(-A2:G2<0),A2:G2)
Hope this helps
Cheers
JulieD
"hungryman" wrote in message
...
I have a list of dates witten sequentially in a row on the sheet. Under
some
of these I have some values. I need to find the non-blank value
associated
with the latest date. Is there an easy way of doing this?
|