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 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