Comparing Data in 2 columns

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

Guest

I'm comparing data in 2 columns. I need to find unique cells that are located
in Column B that are not in column A.
 
In column C, put this formula:

=IF(COUNTIF($A$2:$A$100,B2)=0,"X","")

and copy it down

This will show an X next to the items in column B that aren't in column A.
 
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
Showing data unigue to multiple columns in a pivot table 1
comparing columns in two spreadsheets 1
matching & combining data from seperate worksheets 2
Comparing 3 Columns 2
Finding unique data between 2 columns 4
Two columns of data - How to get the unmatching cell data to colum 1
lookup with multiple condition, but one condition to satisfy is en 2

Back
Top