Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Unique Records from two lists | Excel Worksheet Functions | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
Duplicates - deleting to get just unique ones | New Users to Excel | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
Deleting both duplicate records | Excel Discussion (Misc queries) |