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