Hi,
I am trying to create a function crosschecks 2 column's with another 2 columns and takes out any of the duplicates.. adding them to a third set of columns.. to be a little more precise.. Column A & B is the First and Last names of a group of 2000 people.. Column C & D is the first and last names of a group of 1700 duplicate names from column A & B.. so there are 300 names in A & B that are not in C & D... what I am trying to do is find a way to get those names put into column E & F.. is there a way I can do it with functions? if not.. can someone help me find an easier way of doing it than just going down each list and trying to find the names one by one?
thanks,
ben
Bookmarks