Matching values in 2 Columns

  • Thread starter Thread starter Portuga
  • Start date Start date
P

Portuga

Hello,

In Column A I have a list of unique case Numbers. (around 3000)
A1 123456
A2 234567
A3 345678

In Colums B I have a list of unique case Numbers (around 4000).
B1 654321
B2 543210
B3 123456

Some of the numbers in column A are the the same as in column B. Mos
of them are not.

Is there a way to get only the numbers that are common to bot
Columns?

(In the exemple above A3 = B3) That is the only case number I'
interested in having. At the moment I need to go through both colum
list and see which ones are the same...

Help
 
Hi,

Enter the following array formula(with CTRL+SHIFT+ENTER) in C1:

=IF(ROW()>SUM(COUNTIF($A$1:$A$300,$B$1:$B$400)),"",SMALL(
IF(COUNTIF($A$1:$A$300,$B$1:$B$400)>0,$B$1:$B$400,""),ROW()))

and fill down


--
Regards.
Soo Cheon Jheong
_ _
^ ^
~
 
Back
Top