is it possible to combine data sets, eliminating duplicates?
 

I'm trying to combine two extensive columns of data, to only look at
the number NOT in BOTH sets. Does anyone know of a way to do this in
excel? Basically we need the data that is the DIFFERENCE between the
two columns.
Any suggestions?
Thanks.
-wayne

is it possible to combine data sets, eliminating duplicates?
 

Hi

Assuming your data is in column A and column B.

In column D enter in D1
=IF(COUNTIF(B:B,A1),"",A1)
in E1
=IF(COUNTIF(A:A,B1),"",B1)
Copy down for the extent of data in each column

--
Regards

Roger Govier


wrote in message
oups.com...
I'm trying to combine two extensive columns of data, to only look at
the number NOT in BOTH sets. Does anyone know of a way to do this in
excel? Basically we need the data that is the DIFFERENCE between the
two columns.
Any suggestions?
Thanks.
-wayne