Robert has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Address Lists
Given two address lists that include many exact duplicates, can I get Excel to hightlight those that are NOT duplicated between the two lists? Can this be done without sorting the lists? Thanks RH
RE: Address Lists
you could try adding a pivot table based on address line one for example. For each address line it will sum up how many rows have the same one. If there is a value of 1 in the table then there are no exact matches.