Hello,
I have a mail list with 5 different columns; First name, last name, street address, city, state, and zip.
What i want to do is delete the duplicate values (like husband and wives). I don't want to send the same mail to the same house.
Ive tried using the "delete duplicate values" function but the First name messes it up and and if i just focus on the Street address and city it moves it up mixing the data.
I used to sort everything then use the highlight duplicate values tool and delete one row at a time manually but i figured there should be a better way.
Any thoughts?
Thanks
Bookmarks