matching data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top