Thread: matching data
View Single Post
  #1   Report Post  
Ron
 
Posts: n/a
Default matching data

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