Forum Discussion
Proofing a hotel list
Thank you for your response to this.
I'd say 'kinda' on the apples to oranges comparison. It's comparing 1 list of names to another list of the same names with possibly slightly different variations in some of the names.
Most of the names on both lists, however, do match up, so the differences are probably on a very small percentage of the names.
The information in the details section of the link you sent, though, sounds about what I am looking for.
I haven't tried your solution, but I plan to do that this week.
Thank you so much for what you sent! I'll send an update when I have one.
Hi BHamilton50
Not sure what you looked at but I would recommend the Power Query route
Another recommendation (I had surprises that are difficult to explain...): if names in one or both list(s) contains non-alpha chars., ex.: comma, underscore... start by removing those chars before trying to Fuzzy match