I am comparing two columns of dates to check if there are dates in the same
row for both columns

" =IF(ISNUMBER(A3),IF(ISNUMBER(C3),C3,"Not Processed")) "

This returns the date in C3, IF A3 AND C3 are both entered, The text "Not
processed" IF A3 is entered and C3 is not entered,
OR False if A# is not entered.

This formula is in Column F. I then want to check the index of column F to
return the Date OR the Text of the last non blank value in column F

I am now using " =INDEX(F:F,MAX(IF(ISNUMBER(F1:F65535),ROW(F1:F6553 5)))) "

This will only return a valid value if it is a date. If it is the text it
ignores it.


How can I get the INDEX to return the value of either a date or the text,
and still ignore it if it is FALSE?

Bob Weeden