I have a single column spreadsheet with thousands of rows of business names.
There are many, many duplicates which are easy enough to find and purge. However are even more partial matches. For example, there is a law firm that I have seen listed multiple ways -
Jones, Smith and Paul
Jones, Smith, and Paul
Jones, Smith & Paul
Jones, Smith & Paul, LLC
Jones, Smith, Johnson & Paul, LLC
There are so many variations in these business names. The idea I keep coming back to is creating a formula to highlight cells than contain X% of same text/characters. That way, I could make a few passes, say one pass with 50% matching text, 75% matching text, etc.
I have been scouring the google and while I come across many posts asking similar things, I haven't come across anything that will solve this for me.
1条答案
按热度按时间pokxtpni1#
对于任何人谁遇到这个在未来，微软做了一个Excel插件称为模糊查找，完成正是这种部分/百分比为基础的匹配。