Bob,
I tried this with no luck, do not know what i did wrong.

I put formula in the adjecent colum at the end of my report area and copied
it down.
After that I do not know what you mean by select a value of dup.

Please advise,

JC

"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" wrote in message
...
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.