I am combining several address lists. All lists are in excel. But some of the names of one list are also
on the second and third lists. Is there a formula for combining these lists and excel recognizing the
duplicates/triplicates and then only recording the name once on a Master Listing. I've been (as in the past)
copying, pasting and then
sorting so that I can view the duplicates and then i manually delete the duplicates/triplicates. Alot of time is spent doing this. All lists
are set up the same with last name, first name, address, etc each in a separate column.