I am comparing one list of employees against another list of employees to see what names are on list A, but not on list B. Also, some names in list A are mistakenly listed more than once. I have the Vlookup formula which searches list B for the names on list A, but i want to combine this formula with an IF formula that will eliminate any names listed more than once in the same list. Can anyone help? I hope my description isn't confusing.
Bookmarks