How do I compare two or more columns in an Excel worksheet to identify the difference. The comparison of two columns is related to text and not the numbers. Please advise.
A very similar question here that should answer your question. It may take a little modification for multiple cells, but it should meet your needs.
Not sure you can get the actual substring of either cell as a result to see what is the differentiating portion but I would probably simply throw a column off to the side and use a statement like the following to get a Boolean value in response to two of the columns, then sort the table or filter it to then start looking at what might be another step in filtering.
For some of these comparison tasks I also use a program called WinMerge, awesome stuff there for comparing data. I usually create two text files and compare the content between each other.