Compare data in two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns of similar looking data. Some of the values may match,
while the other may not. Is there a formula for me to find out the data in
one column that do not match with the data in the other
 
Let's say I have 10 records for column A and 20 records for column B. What if
I wanted to list all the records in column B that do not match with column A-
in column C.
 
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

Excel Comparing two columns 1
matching columns to find differences. 0
With F1 value, look at A, if match or partial match return B 5
Compare identifier columns from 2 sheets - remove rows that are dups 2
matching & combining data from seperate worksheets 2
Matching two sets of data? 5
Comparison of columns using Conditional Formatting 3
OR Exact statement not working to compare values in two columns 4

Back
Top