How to compare two cells in one column and then add the vaule of their rows to the matched-cow

[Moe99185]

[FONT=&quot]Hello,
[/FONT]
[FONT=&quot] I have this problem, I have a excel work sheet that contains processes. There are some process with the same name inside the same column “F” which want to compare, because some of them are repeated in other rows. However, the other cells contain different data. What I want to do is to compare the cells in this column “F” and then if there is a match, I want to add the data of the matched-row to the first one and delete the second.
[/FONT]
[FONT=&quot]i.e if F = F then H = H + H and I = I +I, and then delete F which I extracted the data from.
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Can somebody please help figure this out?
[/FONT]

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1105982-compare-two-cells-one-column-then-add-value-their-rows-matched-row.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread