Hi,
First time here, I hope somebody can help me. I have 2 Columns, in Column A I have a string that is 12 characters in length (fixed), in column B I could have exactly the same string, I need to make sure that A2 string = B2, A3 =B3 etc..... if I use the exact function this replies with a true or false answer which is great. However what i need is a true or false answer if 9 or more of the characters match, in the example below the 1st and last strings obviousley fail with the Exact function however I need them to pass as >9 match.
Any examples are greatfully received.
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>
First time here, I hope somebody can help me. I have 2 Columns, in Column A I have a string that is 12 characters in length (fixed), in column B I could have exactly the same string, I need to make sure that A2 string = B2, A3 =B3 etc..... if I use the exact function this replies with a true or false answer which is great. However what i need is a true or false answer if 9 or more of the characters match, in the example below the 1st and last strings obviousley fail with the Exact function however I need them to pass as >9 match.
Any examples are greatfully received.
F0FXE98MUBQF | J0FXE98MJBQF | FALSE |
1ZP0XDJYKG5K | 1ZP0XDJYKG5K | TRUE |
GV7LRZKJGCY3 | GV7LRZKJGCY3 | TRUE |
XBLD06NNNTDS | XBLD06NNNTDS | TRUE |
G9LF2Y4KP49B | G9LF2Y4KP49B | TRUE |
VGLE5JYKXFVM | VGLE5JYKXFVM | TRUE |
291SN1Y8V5AN | 291SN1Y8V5AN | TRUE |
CY97EBEE46TZ | CY97EBEE46TZ | TRUE |
NFXH3KSQC4UE | NFXH3KSQC4UE | TRUE |
S0VM75RDELAR | S0VM75RDELAR | TRUE |
QZL4H7GNH94A | QZL4H7GNH94A | TRUE |
CMRN1YSJQT2Z | CMRN1YSJQT2Z | TRUE |
FTHAAPMLN8JF | THAAPMLN8JF | FALSE |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
<tbody>
</tbody>