ExcelBanter - matching data

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - matching data (https://www.excelbanter.com/new-users-excel/46544-matching-data.html)

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

Try...

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

Hope this helps!

In article ,
Ron wrote:

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