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.

 

[Guest]

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.

 

[smw226 via OfficeKB.com]

Hi JW

There are 2 ways you can do this.

Either put your list into a pivot table which will condolidate it for you,
then copy the results and paste special values

or

(once the list is sorted alphbetically) put a simple forumla in the column
next to your list of
=(A1=A2)

This will give you a result of TRUE if the cells are the same or FALSE if
they are not. Copy the new column and paste special values and sort by your
new column.

Delete all of the TRUE's which will leave you with a unique list.

HTH

Thanks,

Simon

 

[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.