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