Comparing two string columns in excel sheet

japinder.kaur Posts 1 Registration date Sunday May 29, 2016 Status Member Last seen May 29, 2016 - May 29, 2016 at 02:06 AM
Can anybody help me to correct this data? There is a long list of this type of data.I want shortcut method to solve it as if there are columns that are exactly matched like in row number 5(Harley- harley) it should return 1 or 'true' in column C and the columns which are not exactly matched like in Row no 3(Kerry Sean-Kelvin) it should return 0 or 'false' in column C and where there is little mismatching between two columns as Row 1,2,4,6, it should return -1 or 'Mismatched