Duplicate Entries

[JW]

I'm a "casual" user of Excel 2002. I have a single-column spreadsheet
containing about 900 entries, many of them duplicates. I've sorted the list
alphabetically. Is there any good, automated procedure for eliminating
duplicate entries, or is that strictly a long, boring manual process? Thanks
very much for your help, JW.

 

[Traveller]

ASAP Utilities, which is a free add-in easily found by Googling "ASAP
Utilities," makes this an easy job.

After installing the add-in, highlight the range that includes your lists,
and go to "ASAP Utilities/Information/Count Duplicates in Selection." This
will color the cells that contain duplicate data (regardless of order) and
give you a count of duplicates. Easy as pie.

Incidently, this is exactly the answer I gave to a posting just a few days
ago. You can often find answers to your questions by searching in the forum
-- also easy as pie: Just type a key word like "duplicates" in the search box
above.

 

[Lori]

Choose Data|Filter|Advanced Filter with unique records and copy to
another column selected and in the copy to Box select a cell to output
the unique data to.

 

[JW]

Thank you - that worked great!

Choose Data|Filter|Advanced Filter with unique records and copy to
another column selected and in the copy to Box select a cell to output
the unique data to.