Hi All,
I am hoping that some of you may be able to share some wisdom with me. I have been struggling with this for a while with no joy.
Can excel flag two cell that are similair? ie. A1 = excelmadnes5 & A2 = excelmodnes2.... in these two cells there are two character differences. is there a condition or IF statement that can be used to flag two cells as simililair if no more than 2 characters are deffirent in each cell? I am trying to compare two columns from two seperate sources of data entry with a large margins for keystroke errors.
the cells would contain customer names and would be varied from customer to customer..
Any help with this would be hugely appreciated!!!
Many thanks for your help!!
I am hoping that some of you may be able to share some wisdom with me. I have been struggling with this for a while with no joy.
Can excel flag two cell that are similair? ie. A1 = excelmadnes5 & A2 = excelmodnes2.... in these two cells there are two character differences. is there a condition or IF statement that can be used to flag two cells as simililair if no more than 2 characters are deffirent in each cell? I am trying to compare two columns from two seperate sources of data entry with a large margins for keystroke errors.
the cells would contain customer names and would be varied from customer to customer..
Any help with this would be hugely appreciated!!!

Many thanks for your help!!