How to find matching values in two column of data

[medialiver]

Hello All,

I'm looking for a formula that finds the emails (values) listed in coulumn B within the emails(values) in column A.

A1 A554, and C1 C213, are the two range of date in the two columns.

I'm quite a beginner with excel to be honest. Hopefully you could give me few tips that helps me to find the matching data that I need.

Thak so much in advance

[Pepe Le Mokko]

What do you want to do when you have found them? Highlight? Remove?

[medialiver]

Highlight them

[Kalergi]

Hi!
It may help you =MATCH(B2;A:A;0). I don't think that highlight cells can help you in statistics.