#1   Report Post  
Davor ®upanić
 
Posts: n/a
Default Find duplicate

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find duplicate rows then deleting them SSHO_99 Excel Worksheet Functions 4 May 4th 07 11:17 AM
How do I find duplicate rows in a list in Excel, and not delete it Matthew in FL Excel Discussion (Misc queries) 2 June 15th 05 09:11 PM
Find a duplicate value within a list? Arla M Excel Worksheet Functions 2 January 26th 05 10:04 PM
How do you find duplicate values in excel- 2 columns of numbers rickmanz Excel Discussion (Misc queries) 1 December 15th 04 11:16 PM
Another question on how to find duplicate data Eroc Excel Worksheet Functions 2 December 14th 04 05:03 AM


All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"