Excel - Match Closest Partial, Misspelled Text Value - Fuzzy Match Lookup in Power Query

[@mansaha9288]

Good content. Just to add, I am using fuzzy lookup add-on and a similarity column it produces helps a lot. Usually I apply conditional formatting on the column so I can visually see by color their similarities. I can also order them so those that are >0.9 similar would be manually checked later. I think the point of fuzzy match is just to help us form a mapping table

[@wilmarkjohnatty4924]

Your example is too complicated and your video is too long to illustrate fuzzy match.

[@mattsimon931]

I have been scouring the internet for help on text matching customer name, and this video saved me. I don't have it finished yet, but it already helped me audit a gap in our process. Thank you!

[@andymackie4279]

4:06 That tick box "use fuzzy matching.." seems to be missing on some excel builds. Anyone found a solution?

[@adamsmith3676]

It's missing on all Mac builds apparently.. major bummer

[@АндрейБузько-с2и]

Can we do the same in Google Sheets?

[@jameskentwell9237]

It would help me out so much if you did this for Google Sheets!

[@DanKulibert]

Maybe using Apps Script with a fuzzy match javascript library to create the intermediate table and then use SUPERSQL (github.com/chicagocomputerclasses/SUPERSQL-Google-Sheets-Function) to join

[@HiYee856]

Thank you so much. ❤❤❤you saved .me this vide help me a lot ♥️♥️♥️😭😭😭😭

[@MrHorzel]

Great video, thanks for creating this, very helpful. How would you add in a column that shows the percentage match value? Is that possible?

[@CafeRacerRed]

Thank you I've been looking forever for this. I only wished you spoke a little faster during the informational parts and slower during the actual steps. Much too fast the pace.

[@ExcelGoogleSheets]

You can use settings on the video to make it slower or faster.

[@Jhermiful]

You can add a fuzzy look up add on in excel.

[@deepalimallick6344]

Your vedio saved my life

[@mayureshhirlekar5646]

You are the best Thanks a ton

[@JimdalfTheOrange]

Any chance excel’s given us access to this similarity score function so I can use it in a cell to calculate the score?

[@ExcelGoogleSheets]

I doubt they do, but I believe they use Levenshtein distance for this, so you might be able to back engineer the score calculation.

[@hanrealistic]

SUPERB

[@adaajaadv]

how using Fuzzy in 2019 version?

[@ExcelGoogleSheets]

Use addon.

[@zunkman1]

If you keep doing EXCEL stuff, I'm going to unsubscribe.

[@mansaha9288]

I would comment like that, but there is something google ss cant do that excel can at the moment. In this case the mapping table is the product we actually need and excel can help with that. Just use excel to fuzzy map and load it to google ss

[@zunkman1]

@@mansaha9288 Some of us are using Chromebooks and don't have Excel. My suggestion would be to start a channel for only Excel.

[@mansaha9288]

Dan Zunko sorry about that. I am using google ss for about 95%. Still using excel because of some stuffs only excel excels, one of them is fuzzy matching either using dedicated free Fuzzy Lookup add-on or fuzzy match of Power Query. Probably he could provide us alternative of this fuzzy thing done in google spreadsheets

[@ExcelGoogleSheets]

This channel has always been 65% Google Docs, 30% Excel, 5% Other. If that doesn't fit your requirements then you should unsubscribe. Otherwise, I'm happy to have you on board.

[@zunkman1]

@@ExcelGoogleSheets Then you should rename the channel to better describe the content.