matching data

[Ron]

Hello,

I have two columns of numbers. The first col contains

48 48 62 24

The second column contains

48 50 62
I want to see how "close the 2th column is to the first column. Since I can
match the single occurence of 48 and 62 in the 2th column with a single
occurence of 48 and 62 in the first column. I want the result to be 2. Any
suggestions for a formula to achieve this result would be greatly appreciated.

thanks
Ron

 

[Domenic]

Try...

=SUMPRODUCT(--(COUNTIF(A1:A4,B1:B3)>0))

Hope this helps!