Try:
=INDEX(B1:B21,MAX(IF(ISNUMBER(B1:B21)*(B1:B21<0), ROW
(B1:B21))))
Array-entered (meaning press ctrl/shift/enter). Change
the ranges to suit.
This formula will pull the last value, skipping over
blanks, text values, and zeroes.
HTH
Jason
Atlanta, GA
-----Original 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?
.
|