Excel大致文本匹配 [英] Excel Approximate Text Match
问题描述
示例:
$ b我试图检查列A中的字符串数量是否与B列中的字符串相匹配。 $ b
如果我在列B中有字符串angry_birds_iph_app,并且Agry_birds_iph_app和angry_birds_adrd_app出现在列A的某处,我希望该函数返回2。
看看Excel Fuzzy Lookup加载项。可以从Microsoft下载。该工具实现Levenshtein编辑距离算法以返回行之间的相似性分数。除了其他可自定义的功能之外,该工具还允许您设置一个阈值,以了解值必须匹配的程度才能返回近似结果。
而不是像您提到,该工具将返回一个列A中与列B中每个条目最匹配的表。从那里可以简单地使用过滤器并对结果列执行计数。
http://www.microsoft。 com / en-us / download / details.aspx?id = 15011
I'm trying to check how many strings in column A approximately match a string in column B.
Example:
If I have the string "angry_birds_iph_app" in column B, and "angry_birds_iph_app" and "angry_birds_adrd_app" appear somewhere in column A, I would like the function to return 2.
Take a look at the Excel Fuzzy Lookup add-in. It is free to download from Microsoft. The tool implements the Levenshtein edit distance algorithm to return a similarity score between rows. Among other customizable features, the tool also allows you to set a threshold for how well the values must match in order to return the approximate result.
Rather than returning the count like you mentioned, the tool will return a table with the most similar match in column A relative to each entry in column B. From there you could simply use a filter and perform a count on the resulting column.
http://www.microsoft.com/en-us/download/details.aspx?id=15011
这篇关于Excel大致文本匹配的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!