That's a pretty impressive formula, but here's the odd thing... TRUE
only brought up 22 records (all duplicate filenames, just as I wanted).
However, it didn't bring up the other 700+ records that have duplicate
filenames. I can't quite understand why this happened.

Just a note, these filenames have a row filled in completely (all the
way across) and the duplicates do not have any information filled out
in other columns (other than the filename) column. Does this affect
the formula?

Bernie Deitrick Wrote:
mirdonamy,

Use another column with a formula like this in row2:

=COUNTIF(B:B,B2)1

Where column B has your filenames. Then copy down to match your data
table, then filter or sort
based on that column, and delete rows where the value of your formula
is TRUE.

HTH,
Bernie
MS Excel MVP


"mirdonamy"
wrote in message
...

My column headers a id, filename, location, and description.

All descriptions are unique.
My filename column has duplicates. For example, flower010104.jpg is
listed twice, with two different descriptions. I want to delete
BOTH
rows containing flower010104.jpg.

So, I want to delete ROWS with duplicate filenames, regardless of
the
description being unique (which makes the 'record' unique).

I have found that I can only filter by 'unique record', but ALL
records
are unique, due to the description.

I need help. How can I do accomplish my task?


--
mirdonamy

------------------------------------------------------------------------
mirdonamy's Profile:
http://www.excelforum.com/member.php...o&userid=30348
View this thread:
http://www.excelforum.com/showthread...hreadid=500305



--
mirdonamy
------------------------------------------------------------------------
mirdonamy's Profile: http://www.excelforum.com/member.php...o&userid=30348
View this thread: http://www.excelforum.com/showthread...hreadid=500305