Hello,
I'm looking to compare two sets of two columns to see if there are any matches. I have almost 4300 entries that have one column with a name, and one column with a date an employee did a trade. This is in A and B. I then have two columns with 800 entries where there was overtime paid out, names in D and dates in E. I'm trying to see if we ever paid overtime while someone was on a trade.
I can't remember at the moment how to compare, if it is possible. I often compare lists of names or lists of dates, but not two columns. I've attached the document.
Thanks!
Bookmarks