Compare and/or select and delete duplicates between 2 columns?

[GaryHatesSpam]

Hi

I have been looking everywhere for what I think should be quite easy, alas with no luck.

I have 2 column of product names in Excel 2019.
I want to highlight or preferably delete products from column 2 that already appear in column 1, without disturbing column 1.

I have tried a couple of formula's to set formatting of the duplicate cells, such as =countif($B:$B, $A1) but this seems clumsy somehow and I can't figure out how to save this to quickly apply to a spreadsheet using a keyboard shortcut etc.


If anyone has a tutorial I can follow, that would be awesome.

Many thanks

Gaz

[hrlngrv]

If column 1 were A2:A1001 and column 2 were Q2:Q501 and column R were empty,

R2: =COUNT(MATCH(Q2,A$2:A$101,0))

filled down into R3:R501. The col R formulas return 1 for column Q values which appear in column A. Select Q1:R501, and apply a filter, select column R equal to 1, clear the visible cells, and remove the filter. What remains in column Q are values not already in column A.