A
*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.
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.