Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete duplicates and more!
I'm trying to delete duplicates lines. I have a list with 40.000
items And the list looks some like this: A42U002-49 (x) A42U002-49-0 A42U002-50 (x) A42U002-50-0 A42U002-50-0 (x) A42U002-50-01 A42U002-51 All lines ending with -0 is the same as line without but not line with -1. So I have to delete all the line mark with (x) Anyone have an Idea how to do this ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete duplicates | Excel Worksheet Functions | |||
delete both duplicates | Excel Discussion (Misc queries) | |||
Delete duplicates in a row | Excel Worksheet Functions | |||
delete duplicates macro to color instead of delete | Excel Programming | |||
Delete duplicates | Excel Worksheet Functions |