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
|