Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find duplicate string
sheet1 look like this:
A 1 2 3 ABCD sdkljfh 123456 askdjfhl aksjdhfl akjsdfhl aksjdfh lakjsdhf laksjdhf 4 Textxxx xxxxx xxx xx xxxxxx TEXTABC xxxxxx x x 098/858-747 5 6 ABCD sdkljfh 123456 askdjfhl aksjdhfl akjsdfhl aksjdfh lakjsdhf laksjdhf 7 Textxxx xxx xx xx TEXTABC xxx Tel. 091/571-6232, 098/814-671 8 9 ABCD sdkljfh 123456 askdjfhl aksjdhfl akjsdfhl aksjdfh lakjsdhf laksjdhf 10 Textxxx xxxxx xxx xx xxxxxx xxxxxx x x Tel. 091/3300-044 11 12 ABCD sdkljfh 123456 askdjfhl aksjdhfl akjsdfhl aksjdfh lakjsdhf laksjdhf 13 Textxxx xxxxx xxx xx xxxxxx xxxxxx x x xxxx. Tel. 031/377-471 14 15 ABCD sdkljfh 123456 askdjfhl aksjdhfl akjsdfhl aksjdfh lakjsdhf laksjdhf 16 Textxxx xxxxx xxx xx xxxxx xxxx. Tel. 091/3300-044 .. .. .. Macro need to do the following: Look for the duplicate of phone number (etc. string at the end of cell A4, A7, A10... A10000) - where the phone number is in following formats: 031/xxx-xxx or 032/xxx-xxx or 033/xxx-xxx or 034/xxx-xxx or 035/xxx-xxx or 098/xxx-xxx or 098/xxxx-xxx or 098/xxx-xxxx or 091/xxx-xxxx or 091/xxxx-xxx and delete the row with original and duplicate (etc. A10 and A16) - with one row above and one row below. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find duplicate string
I want a mp3 player -- Dnereb ------------------------------------------------------------------------ Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182 View this thread: http://www.excelforum.com/showthread...hreadid=400382 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find String in another string - only between spaces | Excel Worksheet Functions | |||
Find Many String options in ONE String | Excel Worksheet Functions | |||
find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
backwards find function to find character in a string of text | Excel Programming | |||
find a string inside another string | Excel Programming |