software

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

quot; =IF(ISNUMBER(A3),IF(ISNUMBER(C3),C3,quot;Not Processedquot;)) quot;

This returns the date in C3, IF A3 AND C3 are both entered, The text quot;Not
processedquot; 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 quot; =INDEX(F:F,MAX(IF(ISNUMBER(F1:F65535),ROW(F1:F6553 5)))) quot;

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
Hi!

Not real sure what you're after.

My best guess:

=LOOKUP(2,1/(F1:F65535lt;gt;FALSE),F:F)

This will return the last entry in the range that is not FALSE.

Biff

quot;R Weedenquot; gt; wrote in message
...
gt;I am comparing two columns of dates to check if there are dates in the same
gt;row for both columns
gt;
gt; quot; =IF(ISNUMBER(A3),IF(ISNUMBER(C3),C3,quot;Not Processedquot;)) quot;
gt;
gt; This returns the date in C3, IF A3 AND C3 are both entered, The text quot;Not
gt; processedquot; IF A3 is entered and C3 is not entered,
gt; OR False if A# is not entered.
gt;
gt; This formula is in Column F. I then want to check the index of column F
gt; to return the Date OR the Text of the last non blank value in column F
gt;
gt; I am now using quot; =INDEX(F:F,MAX(IF(ISNUMBER(F1:F65535),ROW(F1:F6553 5))))
gt; quot;
gt;
gt; This will only return a valid value if it is a date. If it is the text it
gt; ignores it.
gt;
gt;
gt; How can I get the INDEX to return the value of either a date or the text,
gt; and still ignore it if it is FALSE?
gt;
gt; Bob Weeden
gt;
gt;
One of:

=IF(ISNUMBER(F65536) ISTEXT(F65536),F65536,
INDEX(F1:F65535,
MAX(IF(ISNUMBER(F1:F65535) ISTEXT(F1:F65535),ROW(F 1:F65535)))))

which needs to be confirmed with control shift enter, not just with enter.

=IF(ISNUMBER(F65536) ISTEXT(F65536),F65536,LOOKUP( 2,1/(ISNUMBER(F1:F65535) ISTEXT(F65535)),F1:F65535))

R Weeden wrote:
gt; I am comparing two columns of dates to check if there are dates in the same
gt; row for both columns
gt;
gt; quot; =IF(ISNUMBER(A3),IF(ISNUMBER(C3),C3,quot;Not Processedquot;)) quot;
gt;
gt; This returns the date in C3, IF A3 AND C3 are both entered, The text quot;Not
gt; processedquot; IF A3 is entered and C3 is not entered,
gt; OR False if A# is not entered.
gt;
gt; This formula is in Column F. I then want to check the index of column F to
gt; return the Date OR the Text of the last non blank value in column F
gt;
gt; I am now using quot; =INDEX(F:F,MAX(IF(ISNUMBER(F1:F65535),ROW(F1:F6553 5)))) quot;
gt;
gt; This will only return a valid value if it is a date. If it is the text it
gt; ignores it.
gt;
gt;
gt; How can I get the INDEX to return the value of either a date or the text,
gt; and still ignore it if it is FALSE?
gt;
gt; Bob Weeden
gt;
gt;

THAT was what I was after... Thanksquot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; Not real sure what you're after.
gt;
gt; My best guess:
gt;
gt; =LOOKUP(2,1/(F1:F65535lt;gt;FALSE),F:F)
gt;
gt; This will return the last entry in the range that is not FALSE.
gt;
gt; Biff
gt;
gt; quot;R Weedenquot; gt; wrote in message
gt; ...
gt;gt;I am comparing two columns of dates to check if there are dates in the
gt;gt;same row for both columns
gt;gt;
gt;gt; quot; =IF(ISNUMBER(A3),IF(ISNUMBER(C3),C3,quot;Not Processedquot;)) quot;
gt;gt;
gt;gt; This returns the date in C3, IF A3 AND C3 are both entered, The text quot;Not
gt;gt; processedquot; IF A3 is entered and C3 is not entered,
gt;gt; OR False if A# is not entered.
gt;gt;
gt;gt; This formula is in Column F. I then want to check the index of column F
gt;gt; to return the Date OR the Text of the last non blank value in column F
gt;gt;
gt;gt; I am now using quot; =INDEX(F:F,MAX(IF(ISNUMBER(F1:F65535),ROW(F1:F6553 5))))
gt;gt; quot;
gt;gt;
gt;gt; This will only return a valid value if it is a date. If it is the text
gt;gt; it ignores it.
gt;gt;
gt;gt;
gt;gt; How can I get the INDEX to return the value of either a date or the text,
gt;gt; and still ignore it if it is FALSE?
gt;gt;
gt;gt; Bob Weeden
gt;gt;
gt;gt;
gt;
gt;