Deleting Duplicate Entries in a List

[Scott Sackville]

I am working with a list of people and addresses, a
registered voter list. For a mailing, is there a way to
delete the duplicate addresses so I will only send one
letter to each household?

Thanks

 

[Tom S.]

I'm not an expert, so this is not totally automatic, but:
Sort your spreadsheet, using the address column as the
key. Add a column, with the formula: =IF
(C1=C2, "DELETE", ""), and copy this all the way down (so
in the next row it would read C2=C3, etc.). What this
does is that the sort puts duplicates (exact dupes) in
adjacent rows, and the formula puts the word DELETE where
the dupes occur. Then, I guess, you could do another
sort on the word DELETE to bring them all to the top of
the spreadsheet, rather than paging down to look for them.
(Caution: if you're not familiar with "sort": Make sure
you select the entire spreadsheet for sorting, otherwise
you can move the data in only the one column).

 

[Tim Otero]

You could use Advanced filters, I could explain, but Debra Dalgleish is a
much better authority:
http://www.contextures.com/xladvfilter01.html

Go to Filter unique records.

tim