Hi, your file would be best processed with R (programming language). I understand you need to "deduplicate" addresses only and that you have "states, cities and abbreviations" already the same for the same data (but I will check them too). I also understand that there is no data from the same client having same address, city and state to be kept (e.g. the other data is not important as soon as first unique match is found, all other rows having same address, city and state should be discarded). As final result I would return you an Excel file back and a R script so you could repeat the process if needed for similar tasks in the future (R is free to download and use). Best Regards, Matt