Hi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For each of the cells in column A excel should match the first five characters in column B .if it finds a cell in column B which has the same first five characters as in column A , it should check if all of the remaining characters except any one is same.If it is then it should say true or else false.
So for eg my data could look like this
In this case I should get true as the second cell in col B satisfies both the conditions.Also the length of the strings in col A is not consistent. so one could be 10 character long and other could be 8 character long and so on and so forth.
Need this urgently so will appreciate any hrlp on this