Matching word phrases over different cells
Solved/Closed
localeman
-
May 27, 2011 at 08:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2011 at 10:21 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2011 at 10:21 AM
Hello,
I receive batches of text and need to weed through the duplicates. I have figured out how to find exact matches like "Good Food"repeated the same over many cells... but how do you get excel to also find "Food Good"?
"good food" and "food good" are in separate cells in the same column, if that helps. Please help :)
I receive batches of text and need to weed through the duplicates. I have figured out how to find exact matches like "Good Food"repeated the same over many cells... but how do you get excel to also find "Food Good"?
"good food" and "food good" are in separate cells in the same column, if that helps. Please help :)
Related:
- Matching word phrases over different cells
- Word apk for pc - Download - Word processors
- Number to text in word - Guide
- Word full screen - Guide
- Word watermark on all pages - Guide
- Backspace not working in word - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 27, 2011 at 09:00 AM
May 27, 2011 at 09:00 AM
I think for that you have to code to do a fuzzy search. A lot depends on how the search should go. As you said "Good Food" and "Food Good" is a match. Then is "Food is Good" a match too. or "Good Mood" is a match ? depends
May 27, 2011 at 09:13 AM
May 27, 2011 at 09:30 AM
May 27, 2011 at 09:36 AM
May 27, 2011 at 10:21 AM
Sample Call : =isCommon("Food Good", "Good Food")