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


--
bsoder
------------------------------------------------------------------------
bsoder's Profile: http://www.excelforum.com/member.php...o&userid=29308
View this thread: http://www.excelforum.com/showthread...hreadid=490282