1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Identifying entries that *could* be fixed by fuzzy match

Is there any way to pull a list of entries that would, in fact, be fixed by a fuzzy match without relying on the fuzzy match itself (data still needs to be manually reviewed at the end of the day) . Best I can think of is running the fuzzy match itself in power query and then adding a column that checks if the result is the same as the original input data but I have to imagine there’s a better way to do it (and it’s a comparison between 8 separate tables which is my secondary question lol)

TLDR trying to find the best way to identify entries that are close, but not quite the same across multiple tables. We’re talking stocks, so META vs META US for Facebook as an example of the data inputs that should be pinged

submitted by /u/Codenamerondo1
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#natural language processing for spreadsheets
#Excel compatibility
#Excel alternatives
#fuzzy match
#data review
#power query
#multiple tables
#entries