Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams. Connect and share knowledge within a single location that is structured and easy to search. I have a huge file that is similar to the one below.
I'm basic user with formulas and can use VBA to save and run macros. Small notes, the columns do have duplicates and the comparison needs to be done only on cell by cell E. Even a simpler form of this will help. Thank you.
Try Teams for free Explore Teams. Learn more about Teams. Excel: How to compare two text strings and flag the ones Ask Question. Asked 8 years, 8 months ago. Modified 8 years, 2 months ago. Viewed 7k times. The closest answer I could get was How can I compare two columns in Excel to highlight words that don't match?
Improve this question. Community Bot 1. Please note that Super User is not a script writing service. If you tell us what you have tried so far including any scripts you are using and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question? Sounds like "Fuzzy Lookup" is what you want. Search that on the web. Just tried Fuzzy Lookup but the similarity match is too high to get actual, good data. It stays around. Add a comment.
Sorted by: Reset to default. Highest score default Date modified newest first Date created oldest first. Improve this answer. Gary's Student Gary's Student The way the data is set in the table is A1: Classement fifa, B1 green grass soccer.
