Putting Values in visible rows based on a date criteri

0

I have a file where I ahve a filtered Column D and I select an Item from Column D. A few visible rows appear based on that selection. Now there are two date columns ( A & B) where A is Start Date & B is End Date.

I need to check whether the second visible row's End Date (Col B) is less than first row's End Date. If Yes, corresponding cell of Column C must have 'Yes' printed else 'No'

Can anyone help urgently please?

Answer
Discuss

Answers

0

=IF(A1<B1,"Yes","No")

Try that.

Discuss
0

You may need to copy the filtered list to a different column....reason being that the filtered list MAY hide rows.  Once this is done, formula very much like Don's =IF(B2>B3,"LessThan","")....If the first row is header and the 2nd row contains the first date, you will have to put this in the row below that (Example Header in Row 1, 1st date in row 2, then copy formula above to row 3)

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login