Hi Everyone,
I am using the formula below:
=IF(OR(G2="DL",G2="DM",G2="FD",G2="LP",G2="RM",AND(I2<H2)),"DELETE","")
To try and do the following but for some reason it isn't working.
In column G there are a total of 7 possible values, of the 7 I only want excel to look at the cell if it includes one of the 5 listed above (DL,DM,FD,LP,RM) - once excel recognizes that one of the 5 words is listed in column G I then want it to see if column I is greater than column H (this field is a date). If both of those things are present, I want it to list the word "delete", if not - I want it to show as blank.
Basically any cell in G that has DL, DM, FD, LP or RM that also has a date in column I that is less then the date in column H will be deleted. I want the formula to appear in column N titled "DELETE" (see attached example)
Any suggestions on this one?
Thank you!
Bookmarks