I'm using Power Query to merge two queries together and match some columns using fuzzy matching. When I do this, I'm not given the option to use fuzzy matching under the "Join Kind" bar. Has that button been moved to somewhere else? I'm using Excel 2016 and since I'm on a work computer I can't update it or change the software much.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Fuzzy Matching Missing
- Thread starter M0X3
- Start date
severynm
Active Member
- Joined
- Jan 8, 2021
- Messages
- 362
- Office Version
- 365
- Platform
- Windows
You're looking for this (integrated into PQ), and not the old Excel addin, correct?
I can't 100% confirm this, but according to this comment, and the fact that the subheading on the support page says "Excel for M365", leads me to believe it is a 365 exclusive function at this time.
I can't 100% confirm this, but according to this comment, and the fact that the subheading on the support page says "Excel for M365", leads me to believe it is a 365 exclusive function at this time.
Upvote
0
Similar threads
- Question
- Question
