+ Reply to Thread
Results 1 to 2 of 2

Find duplicate string

  1. #1
    Davor ®upaniæ
    Guest

    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. #2
    Registered User
    Join Date
    08-11-2005
    Location
    Netherlands Waddinxveen
    Posts
    81
    I want a mp3 player

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1