Hi! I'm trying to have excel return a date overlap. The criteria I have for this are, If the name (Column A) is the same, RA (Column B) is different, the end date (Column D) is not the same, and there's overlap then flag this row down.
So for example, Row 13 and row 7 should be flagged down because they have the same name, different RA, different end dates, and an overlap. Row 8-12 are acceptable because the end dates are the same.
I've been using the Sum product function but I can't seem to find a way to include the same end date criteria. Any ideas?
So for example, Row 13 and row 7 should be flagged down because they have the same name, different RA, different end dates, and an overlap. Row 8-12 are acceptable because the end dates are the same.
I've been using the Sum product function but I can't seem to find a way to include the same end date criteria. Any ideas?
