is it possible to combine data sets, eliminating duplicates?

W

wam525

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
 
R

Roger Govier

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
 
Top