Find duplicate

D

Davor ®upaniæ

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How...? 0
Find duplicate string 1
How to... with macro? 0
Count 3
Word created document; but would like to add "excell" style simple 3

Top