Can anybody help me to correct this data? There is a long list of this type of data:
- If there are columns that are exactly matched, like in row 5 (Harley- harley) it should return 1 or 'true' in column C.
- The columns which are not exactly matched, like in Row 3 (Kerry Sean-Kelvin), it should return 0 or 'false' in column C,
- Where there is little mismatching between two columns as in rows 1, 2, 4, and 6, it should return -1 or 'Mismatched'.