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

 

[Nishith Desai]

Dear friend,
This is one of the common question asked by the poster on
all the forum.
It is very simple, the thing is we dont know the facility
provide by excel.
You can make use of filter function provided by the excel.
goto -> Data -> filter -> advance filter.

Here you can give the option in the form..it is self
explanatory. If you have still have problem then you can
visit my web site www.pexcel.com and goto download
section. and download file for unique entries it is free
with code. there are two types of files.
feel free to write me on (e-mail address removed)

nisht
www.pexcel.com