Comparing Data in 2 columns

S

suzb

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.
 
M

Myrna Larson

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.
 

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

Need Help with a VBA subroutine 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
comparing sheet to sheet and adding value 1
Trying to count based on multiple criteria & cell comparisons 4
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Autonumber field in Excel that behaves the same as Access 0
Consolidation Table from Different Excel Tabs with Different Format 1
Need help merging Excel into Publisher Booklet w 2 columns 0

Top