Pat needs to find duplicate addresses. However, the addresses are typed differently, data is in different columns, it is a real mess.
In Episode 806, we will take a look at using FuzzyMatch functions from the MrExcel Message Board to solve this problem.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!