I need to be able to rate the similarity of two columns, purely on a 'hit or
miss' basis on each cell. I apologise if this is confusing!

For example:
If column A looks like:
1

1
1
1

1

and column B looks like:

1
1

1
1
1

(where 1 is a 'hit' and a blank is a 'miss' for 7 bits of data) Is there a
way of comparing the two and achieving a value of similarity or dissimilarity
(ie % difference)?

Thank you anyone who got this far!