I am looking to count the amount of matches between to columns
here's my example (my data is obviously a bit bigger, but there are no duplicates in each column)
Column A Column B
beer tea
coffee wine
milk sprite
tea juice
coke milk
gin water
So I would want a total number of matches between two columns, which should equal 2.
Anyone got any help they can give?
thanks again to the forum.
Bookmarks