How to find the match between text that typo in Excel?

I have two columns of data with an hundred names on and I need to find the matches. The problem is when names on the second column are not exactly the same as the first column. Its hard to match them with a hundred names. Is there any formula in excel for at least give tolerance with the data like "Setyadi" with "Setiadi", or "Tak Jelan" with "Tak Lejan". ------ Thanks for the solution, it works, I edited this because I want to ask more, I have another problem, could you help me again? I have a data like this, I want to fill column C with a number according to match the name in column D with column A. The other problem is, I want to match the name that only in a group that mentioned in column E, even not in the same row. From A | B | c | D | E | Setyadi | 1 | | Setiadi | 11 | Tak Jelan | 2 | | Tak Lejan | 11 | Gordon | 3 | | Herik | 12 | Alex | 4 | | Goerdon | 12 | Heri | 5 | | Alex | 12 | Into A | B | c | D | E | Setyadi | 1 | 1 | Setiadi | 11 | Tak Jelan | 2 | 2 | Tak Lejan | 11 | Gordon | 3 | 5 | Herik | 12 | Alex | 4 | 3 | Goerdon | 12 | Heri | 5 | 4 | Alex | 12 | What I need is, how can we compare the name in group that mentioned in column D, then We can automatically give the number in column C that coupling from column B. Thanks in advance

以上就是How to find the match between text that typo in Excel?的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏