• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

compare columns to find non matches

W

wnorrick

Member
I have two columns of names and need to find which ones are not duplicates. There are 479 names in one and 418 in the other column and I need to find out which ones are missing in the shorter column.

Thank you for any help.
 
Wnorrick


Chandoo has any number of posts on finding duplicates

Try using the Google Custom Search box at the top right of this and every page at Chandoo.org


Try searching for Find Duplicates or Find Data Missing from Second Column
 
Thank you. I accidentially posted too soon on this one and then did an edit. I found some of the posts on finding duplicates however the sentence I left out on this one was that I would then like for the non matches to go to a new spreadsheet along with all of their columns to the left of the name.

I haven't seen anything for that, any suggestions.
 
Hi, you cab use the conditional formating for that.


Select both the column > Home> conditinal formating > Highlight cells Rules> Duplicate Values


There you find two drop down.


In the first drop-down the default one is Duplicate you can change to Unique and apply it.
 
You must log in or register to reply here.
Back
Top