Comparing 2 Columns of Data in Excel

[culm]

I have two columns of email addresses.  I want to identify (but not remove) any email addresses that are in both columns.  Any advice greatly appreciated!  Charles

[#2]

Hello

This is a frequently asked task and there are about 59 millions Google hits to choose from.

Hit #1.

[#3]

Hi @culm,

Is this ok for you

[#4]

Success! Thanks for the advice.

[#5]

All good now thanks Logaraj.