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

Zsolty87
Mar 28th 2019
Thread is marked as Resolved.

Zsolty87

Beginner

Points

35

Posts

3
Mar 28th 2019
- #1
[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
Images

image_74284.png

97.29 kB

277×280

67
Quote
Carim

OzMVP (0007*2) - 4

Reactions Received

916

Points

36,086

Posts

6,994
Mar 28th 2019
- #2
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
Quote
Zsolty87

Beginner

Points

35

Posts

3
Apr 1st 2019
- #3
[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
Quote

Participate now!

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

Register Yourself Login

Share

Navigation
OzGrid
Forum
1. Unresolved Threads
2. Forum Rules
Dashboard
Articles
Privacy Policy
Search
Options
Current Location
OzGrid Free Excel/VBA Help Forum
Forum
HELP FORUMS
Excel VBA / Macros

User Menu
Login or register

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.