Kotes@kotaro@kotaro.me
This morning, I was writing a custom function for Excel using VBA.
Someone in our client's PR department makes a lot of typos. So, when I'm trying to aggregate article performance data, VLOOKUP can't find a match for the article titles he types in, whether I use an exact or partial match.
So, I decided to implement an algorithm that calculates the similarity between text strings to work around his typos.
It's a real pain to do.