duplicate cells

[Richard Mahan Sr]

I have a spreadsheet of Names and addresses. the list is very large (about
8000) there are quite a few duplicate entries that I would like to
eliminate. is there a formula or a uncomplicated method that will do this
for me? bear in mind that I am a novice with excel spreadsheets.d appreciate
any help. Thanks

 

[Paul B]

Richard, have a look at Chip's site for a way to do it.
http://www.cpearson.com/excel/deleting.htm#DeleteDuplicateRows

You may also what to have a look here on getting started with macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm

if you need more help post back with what you need

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Bob Phillips]

You could use Data>Filter>Advanced Filter.
Check the Unique box and specify a location to copy to
When copied, delete the original.