I m following directions and can't delete dup rows in excel

[mickeyfinz]

I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
success. Any ideas. M I missing some'ting?

[Barb Reinhardt]

What are you doing? Just select the row you want to delete, right click and
select DELETE.

"mickeyfinz" wrote:

> I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
> success. Any ideas. M I missing some'ting?

[mickeyfinz]

I have a list of approx 3000 names and fax #'s. Included are about 600
duplicates that I want to delete so I have one name and fax number per line
with no duplications. I have followed the instructions in "HELP" w/o any
success. I was wondering if I am not alone?

"Barb Reinhardt" wrote:

> What are you doing? Just select the row you want to delete, right click and
> select DELETE.
>
> "mickeyfinz" wrote:
>
> > I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
> > success. Any ideas. M I missing some'ting?

[Barb Reinhardt]

I have no idea what you are checking in HELP. YOu may want to use a PIVOT
Table to determine which are dups. You could also use conditional
formatting to determine the dups using COUNTIF

http://www.mrexcel.com/tip063.shtml

"mickeyfinz" wrote:

> I have a list of approx 3000 names and fax #'s. Included are about 600
> duplicates that I want to delete so I have one name and fax number per line
> with no duplications. I have followed the instructions in "HELP" w/o any
> success. I was wondering if I am not alone?
>
> "Barb Reinhardt" wrote:
>
> > What are you doing? Just select the row you want to delete, right click and
> > select DELETE.
> >
> > "mickeyfinz" wrote:
> >
> > > I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
> > > success. Any ideas. M I missing some'ting?

[greg7468]

Hi, I am no expert but this works for me.

=IF(COUNTIF(A1:$A$100,A1)>1,"Duplicate","")

If names are in Col a, #'s are in Col B.

Put this in Col C and copy down.

This will put a "duplicate" in Col C where there is a name replication.

Filter Col C to show "duplicates" and delete.

HTH.

[Gord Dibben]

Use the advanced filter method.

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xladvfi....html#FilterUR



Gord Dibben MS Excel MVP

On Wed, 26 Apr 2006 06:47:02 -0700, mickeyfinz
<[email protected]> wrote:

>I have a list of approx 3000 names and fax #'s. Included are about 600
>duplicates that I want to delete so I have one name and fax number per line
>with no duplications. I have followed the instructions in "HELP" w/o any
>success. I was wondering if I am not alone?
>
>"Barb Reinhardt" wrote:
>
>> What are you doing? Just select the row you want to delete, right click and
>> select DELETE.
>>
>> "mickeyfinz" wrote:
>>
>> > I am try'g to delete dup rowsin excell sprdsht, following directions w/o any
>> > success. Any ideas. M I missing some'ting?