HOW CAN DUPLICATES BE DELETED,NOT FILTERED?

Is there a way that Excel can look at a date base (with values) and ID all
duplicates as a value? Let's say there is a value of 102 in the DB and it
shows up 7 times. I want this value in a sepertae column.

Thanks
Larry

"Eve" wrote:

>
>
> "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.
> >
> > --
> >
> Hi Bob,
>
> Thanks to this...its a huge help...however, when i tried to delete all the
> Dups...there are no more remaining for that dup data...it means my count are
> inaccurate because the dups are gone without a trace at of atleast one to
> count...can you advise me..how to maintain one of those dups to have a
> complete count?

Judy, Bob's advice requires a little bit of tweaking. Run his if statement,
then select the column where you marked the dupes. Copy, then paste special
preserving values. Now, go back and manually select all the data except for
row 1. Cut, then paste up one row. Do a visual scan to confirm that the
workaround was successful, then delete all filtered items as before.

"judyb" wrote:

> 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" <naminel.RemoveThis@discussions.microsoft.com> wrote in message
> > > news:69C4F4D7-4FD7-4C22-8FD6-D81A3BD4FD56@microsoft.com...
> > > > 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.
> > >
> > >
> > >