How To Compare Two Columns And Delete Matches In Excel?

If you have two columns/lists including some duplicates, now you want to compare them and find out the matches, the delete them, how can you quickly solve? In this article, I introduce different ways to help you handle it in Excel.

Compare two columns and delete matches with Kutools for Excel (video shows)