A way to identify and delete duplicate entries?

[*alan*]

A couple times I week I run a report on accounts (account numbers are either
7 or 8 digits long) looking for 3 different issues, import the results into
Excel, and distribute the results to be worked on. Since the same account
may have been identified by two or more of the search parameters, the final
report may contain anywhere from 5% to 15% duplicate (sometimes triplicate)
entries. Since it's a bit of a time-waste to even take a look at an
account that may already be in the process of being resolved, is there an
easy way to identify and delete duplicate entries?
Even just identification would be great, as I could manually delete.
Thanks for your help.

 

[JE McGimpsey]

See

http://cpearson.com/excel/duplicat.htm

and

http://cpearson.com/excel/deleting.htm#DeleteDuplicateRows

 

[Lori]

One way is to hide the unique records, then delete the remaining rows:

1. Data > Filter > AdvancedFilter Unique Records Only OK
2. Select visible cells only then Data > Filter > Show All
3. Hide selected rows then select visible cells only again.
4. Edit > Delete Entire Row, then unhide rows again.

This is also recordable as a macro.

Useful shortcuts:
Alt+; = select visible cells only
Ctrl+9 = Hide Rows
Ctrl+Shift+9 = Unhide Rows

 

[*alan*]

Lori --- A very simple and elegant solution. Works perfectly.
Thanks VERY much

 

[*alan*]

Thanks very much for the links. They look quite useful.

 

[Lori]

Glad it worked for you. Thanks for the comeback

Lori --- A very simple and elegant solution. Works perfectly.
Thanks VERY much
--
Alan










- Show quoted text -

 

[*alan*]

You're welcome. I really appreciate your help and the help that other
posters to this newsgroup have given to me and others. You people provide
an excellent resource and I know that untold thousands of folks have had
their Excel problems resolved through your efforts. Excel help files
really don't seem to be that helpful, googling for a solution can be
unproductive if you don't know enough to phrase your queries just right, and
you folks that have actually used Excel in real work situations seem to be
able to really explain things very well.
Wish there was a way I could show my appreciation more.