Delete rows on duplicate text and add its values to the first

  • [ATTACH=JSON]{"data-align":"none","data-attachmentid":"1216670","data-size":"custom","height":"540","width":"534"}[/ATTACH]


    Hi everyone.


    What I would like here is to compare the texts in column B, if the below cell is the same then ad its value to the first one and delete the row.


    But for example B10 and B11 are not the same as B33:B35 so I would like to compare only the ones which come one after the other.


    See Image above with the first table as raw data and the second as treated data.


    Please help.


    Thank you

  • Hello,


    Unfortunately ... pictures are totally inert objects ... :(


    Why don't you post your file ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 907"]

    [tr]


    [TD="align: right"]25-03-2019 07:24:30[/TD]

    [td]

    CIP_CIP_BIF00001_

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    1:31:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 08:55:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    1:02:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 09:57:30[/TD]

    [td]

    NBNG50999

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    2:34:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 12:31:30[/TD]

    [td]

    CIP_NBNG50999

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    0:57:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 13:28:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    0:25:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 13:53:30[/TD]

    [td]

    KON10050

    [/td]


    [td]

    8:00:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    8:20:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 21:53:30[/TD]

    [td]

    KON10050

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    0:20:00

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 22:13:30[/TD]

    [td]

    CIP_KON10050_

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    0:58:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]25-03-2019 23:11:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    8:00:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    8:42:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 07:11:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    0:42:00

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 07:53:30[/TD]

    [td]

    QEN00047

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    1:45:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 09:38:30[/TD]

    [td]

    CIP_QEN00047_

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    2:09:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 11:47:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    0:03:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 11:50:30[/TD]

    [td]

    REN07005

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    4:02:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 15:52:30[/TD]

    [td]

    CIP_REN07005

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    0:59:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 16:51:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    0:23:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 17:14:30[/TD]

    [td]

    CIP_CIP_REN07005

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    1:03:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 18:17:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    0:47:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 19:04:30[/TD]

    [td]

    LQN00118

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    2:19:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 21:23:30[/TD]

    [td]

    CIP_LQN00118_

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    1:10:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]26-03-2019 22:33:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    8:00:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    11:19:00

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]27-03-2019 06:33:30[/TD]

    [td]

    REN_

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    3:19:00

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [/TABLE]


    This is how I managed to work my way through it with IF, AND and EXACT commands and then I have a macro where I select the rows with X and then copy them to a new sheet where I can construct a graph or chart with a treated data.


    Hope this will give you and idea what I would like a VBA code for.


    Thank you

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!