is it possible to combine data sets, eliminating duplicates?

  • Thread starter Thread starter wam525
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining duplicate row data 3
counting duplicates and uniques comparing two columns 3
Excel Comparing two columns 1
Generating Possible Combinations and Assigning ID Number 1
Data Validation Combine Functions 2
Using SUM + INDEX in array formula 5
Combine Duplicates in Query 0
Combining data 3

Back
Top