I'm trying to compare two sets of data and identify which have the same information.
If you look at the attached - I want to conditionally format "ID" and "Occupant ID" for the two sets of data.
So somehow the formula would say - IF "ID" is match, then check to see if "Occupant ID" is a match, if both are true, then either conditionally format them....or, In a separate column if they are both true, put a 1.
Bookmarks