View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ramses[_3_] Ramses[_3_] is offline
external usenet poster
 
Posts: 2
Default 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 ?