Comparing differences between two columns
I have used an If function to compare two columns and have match or mismatch. For the mismatches, I'd like to see how different they are. Is this possible.
Column A Column B Similar/Different
ABC Holdings XYZ Corp Different
ABC Holdings ABC Holdings Plc Similar
Thanks in advance
(I'm using Excel 2002)
Re: Comparing differences between two columns
I would suggest that more details are required here.
For eg. Start with different letters (the first 2,3,4,5,6 letters) have/dont have numbers/text in?
Maybe upload a sample of your desired output
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1