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