HOW CAN DUPLICATES BE DELETED,NOT FILTERED?

[naminel]

I am using Office XP and I was wondering how to delete duplicates. Is there
a procedure in Excel where I can do this in one key stroke? My list consists
of 14,000 lines, so as you can see it would be quite cumbersome to go through
manually to delete them. Any help would be greatly appreciated.

[Bob Phillips]

In an adjacent column, add this formula

=If(COUNTIF($A$1:A1,A1)>1,"Dup","")

and copy down

Then filter column B and select a value of Dup. Delete all visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"naminel" <[email protected]> wrote in message
news:[email protected]...
> I am using Office XP and I was wondering how to delete duplicates. Is
there
> a procedure in Excel where I can do this in one key stroke? My list
consists
> of 14,000 lines, so as you can see it would be quite cumbersome to go
through
> manually to delete them. Any help would be greatly appreciated.

[naminel]

Thank you much. It worked.


"Bob Phillips" wrote:

> In an adjacent column, add this formula
>
> =If(COUNTIF($A$1:A1,A1)>1,"Dup","")
>
> and copy down
>
> Then filter column B and select a value of Dup. Delete all visible rows.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "naminel" <[email protected]> wrote in message
> news:[email protected]...
> > I am using Office XP and I was wondering how to delete duplicates. Is
> there
> > a procedure in Excel where I can do this in one key stroke? My list
> consists
> > of 14,000 lines, so as you can see it would be quite cumbersome to go
> through
> > manually to delete them. Any help would be greatly appreciated.
>
>
>

[judyb]

I tried the same, or almost so, and I must have done something wrong. It has
been a while since I have fooled with this type of thing.

I want to see if col B is the same, and changed the formula to
=IF(COUNTIF($B$1:B1,B1)>1,"Dup","")

Dup is appearing, but in the row after the second occurance.

thanks for any help,
judy

"naminel" wrote:

>
> Thank you much. It worked.
>
>
> "Bob Phillips" wrote:
>
> > In an adjacent column, add this formula
> >
> > =If(COUNTIF($A$1:A1,A1)>1,"Dup","")
> >
> > and copy down
> >
> > Then filter column B and select a value of Dup. Delete all visible rows.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "naminel" <[email protected]> wrote in message
> > news:[email protected]...
> > > I am using Office XP and I was wondering how to delete duplicates. Is
> > there
> > > a procedure in Excel where I can do this in one key stroke? My list
> > consists
> > > of 14,000 lines, so as you can see it would be quite cumbersome to go
> > through
> > > manually to delete them. Any help would be greatly appreciated.
> >
> >
> >