I am attempting to write a formula that will count partial matches between two different ranges.
Column 1 Range: A1:A4
A1 - A123456789
A2 - A6789
A3 - 12345
A4 - 11111
Column 2 Range: B1:B4
B1 - 12345
B2 - 6789
B3 - 11111
B4 - B12345
Basically, I am trying to develop formulas that i can display a count indicating:
The number of times the first 4 characters match
The number of times the last 4 characters match
The number of times the middle 4 characters match
*Note: There are not duplicates within each range.
Any suggestions would be greatly appreciated. Thank you in advance for reviewing my question.