View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mirdonamy
 
Posts: n/a
Default Deleting Duplicates, All records unique


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