A way to identify and delete duplicate entries?

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

JE
Tue Mar 20 20:54:54 CDT 2007

See

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

and

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


In article <B60Mh.163$rO7.37@newssvr25.news.prodigy.net>,
"*alan*" <in_flagrante@hotmail.com> wrote:

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

Lori
Wed Mar 21 06:21:19 CDT 2007

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



On 21 Mar, 01:45, "*alan*" <in_flagra...@hotmail.com> wrote:
> 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.
> --
> Alan

*alan*
Wed Mar 21 19:17:36 CDT 2007

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

"Lori" <lorimer_miller@hotmail.com> wrote in message
news:1174476079.688801.219050@l77g2000hsb.googlegroups.com...
> 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
>
>
>
> On 21 Mar, 01:45, "*alan*" <in_flagra...@hotmail.com> wrote:
>> 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.
>> --
>> Alan
>
>

*alan*
Wed Mar 21 19:18:24 CDT 2007

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


"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-86C40D.19545420032007@msnews.microsoft.com...
> See
>
> http://cpearson.com/excel/duplicat.htm
>
> and
>
> http://cpearson.com/excel/deleting.htm#DeleteDuplicateRows
>
>
> In article <B60Mh.163$rO7.37@newssvr25.news.prodigy.net>,
> "*alan*" <in_flagrante@hotmail.com> wrote:
>
>> 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.
>> --
>> Alan

Lori
Thu Mar 22 07:11:38 CDT 2007

Glad it worked for you. Thanks for the comeback

On 22 Mar, 00:17, "*alan*" <in_flagra...@hotmail.com> wrote:
> Lori --- A very simple and elegant solution. Works perfectly.
> Thanks VERY much
> --
> Alan
>
> "Lori" <lorimer_mil...@hotmail.com> wrote in message
>
> news:1174476079.688801.219050@l77g2000hsb.googlegroups.com...
>
>
>
> > 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
>
> > On 21 Mar, 01:45, "*alan*" <in_flagra...@hotmail.com> wrote:
> >> 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.
> >> --
> >> Alan- Hide quoted text -
>
> - Show quoted text -

*alan*
Thu Mar 22 20:13:03 CDT 2007

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

"Lori" <lorimer_miller@hotmail.com> wrote in message
news:1174565498.425045.50180@n59g2000hsh.googlegroups.com...
> Glad it worked for you. Thanks for the comeback
>
> On 22 Mar, 00:17, "*alan*" <in_flagra...@hotmail.com> wrote:
>> Lori --- A very simple and elegant solution. Works perfectly.
>> Thanks VERY much
>> --
>> Alan
>>
>> "Lori" <lorimer_mil...@hotmail.com> wrote in message
>>
>> news:1174476079.688801.219050@l77g2000hsb.googlegroups.com...
>>
>>
>>
>> > 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
>>
>> > On 21 Mar, 01:45, "*alan*" <in_flagra...@hotmail.com> wrote:
>> >> 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.
>> >> --
>> >> Alan- Hide quoted text -
>>
>> - Show quoted text -
>
>