Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Find a duplicate value within a list? | Excel Worksheet Functions | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions |