"JohnL" wrote:

Sorry, in rereading my post I caught an error.
In cell H2 (NOT cell H1) type FALSE.
In cel H3 (NOT cell H2) type in the equation.

Sorry for the confusion.

"MRJ" wrote:

I'm not exactly sure how to post a sample, but the way the spreadsheet is
laid out is with info in columns: first name, last name, street address 1,
street address 2, city, state, zip.

If I am dealing with a short list, it is simple to select the duplicates and
delete. When you're dealing with a list of 5,000 though, another method is
required.

Thanks,

MRJ

Perhaps you could use the AND() function.

A B C D E F G
FNam LNam Addr1 Addr2 City St Zip
John Doe 13 Main St Anytown RI 2913
John Doe 13 Main St Anytown RI 2913


First you need to sort the data:

Data Sort with the first Sort By being Addr1 and the second Sort By being
Addr2 and the third Sort by being City.

In cell H1 type in FALSE.
In cell H2 enter:
=AND(A3=A2,B3=B2,C3=C2,D3=D2,E3=E2,F3=F2,G3=G2)

Copy the equation down for the entire list of data.

If each and every cell on row "3" equals each and every corresponding cell
on row "2", then the answer is TRUE.
If not, the answer is FALSE

Delete every row whose "answer" is TRUE.



"OssieMac" wrote:

Post a sample of how the data is laid out on your worksheet.
--
Regards,

OssieMac


"MRJ" wrote:

How do I eliminate duplicate addresses in a mailing list?