Matching e-mail from 2 colums

[BokiB]

Hey guys,

I have the following issue:

I have two colums containing e-mail adresses from 2008 and 2010.

A B
ab@ms.com ab@ms.com
ba@ms.com bb@ms.com

I would like Excel to go through these colums and return only the ones
which are in both colums (ab@ms.com, for example)

How can I do this?

Thanks for your help!

 

[shift-del]

Hi BokiB

<table valign="middle" colspan="4" style="font-family: Calibri; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11px; font-weight: normal; font-style: normal;" border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28pt"><col width="60pt"><col width="60pt"><col width="60pt"></colgroup><tbody><tr style="background-color: rgb(250, 250, 250);"><td colspan="4" align="middle">Worksheet 'Tabelle1'</td></tr><tr style="background-color: rgb(202, 202, 202);"><td>
</td><td align="middle">A</td><td align="middle">B</td><td align="middle">C</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">1</td><td align="left">a</td><td align="left">b</td><td align="left">b</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">2</td><td align="left">b</td><td align="left">d</td><td align="left">g</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">3</td><td align="left">g</td><td align="left">p</td><td align="left">d</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">4</td><td align="left">f</td><td align="left">g</td><td align="left">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">5</td><td align="left">d</td><td align="left">o</td><td align="left">
</td></tr></tbody></table>
<table valign="middle" colspan="2" style="table-layout: fixed; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; font-size: 10px;" border="3" cellpadding="2" cellspacing="0"><colgroup><col width="40pt"><col></colgroup><tbody><tr style="background-color: rgb(238, 170, 170);"><td>Cell</td><td>Formula</td></tr><tr><td>C1</td><td>{=IF(SUM(N(COUNTIF($B$1:$B$10,$A$1:$A$10)))<ROWS($C$2:C2),"",INDEX($A$1:$A$10,SMALL(IF(COUNTIF($B$1:$B$10,$A$1:$A$10)=1,ROW($A$1:$A$10)-ROW($A$1)+1),ROWS($C$1:C1))))}</td></tr></tbody></table><table style="font-family: Arial; font-size: 8pt; background-color: rgb(255, 255, 255);"><tbody><tr><td style="font-weight: bold;">Contains array formula!</td></tr><tr><td>Do not enter the curly brackets {}.</td></tr><tr><td>Enter the formula with CTRL-SHIFT-ENTER instead of just ENTER.</td></tr></tbody></table><table style="font-family: Arial; font-size: 7pt;"><tbody><tr><td style="color: rgb(51, 51, 51);">Created and displayed with Tab2HTML (v2.4.1). ©Gerd alias Bamberg</td></tr></tbody></table>