Adding Duplicates and deleting duplicate rows

Thanks for looking at my post.
Any help will be much appreciated and thanks again for your time and effort.

I have two sheets

Sheet1 and sheet2

I would like sheet1 to be like sheet2 please. Sheet2 is the result what i am looking for tbh
Basically, I have number with sometimes its duplicating. I have added formula in column F if it is duplicate or not.
If it is duplicate then i would like to add corresponding column in respect to number and delete the duplicate.
That is for example, number 3 is repeating three times. In this case column B will be 15, Column C will be 28 (15+9+4), column D will be 16 (0+12+4), column E will be 30 (10+8+12)
After adding rest of the 2 duplicate need to get deleted and leaving only one time 3 rather than three times please.

Hope i explained it. If not please let me know.

Thanks again

Please Login or Register  to view this content.

That's fantastic. Thanks a lot for your time and effort. One last question what if I need to add some condition on it. Like example I wanted to add only if column B have word called "Condition 3" please.

I have added workbook with sheet1 as raw data and sheet 2 as how the result looking for please.

Thanks again for brilliant work

Please Login or Register  to view this content.

Brilliant.

Thanks a lot again for your time and effort

Thanks,
Kind regards,
Jim

Hi,

Sorry to reopen this post.

I am using same vba code for another condition where I don’t have any criteria and just need to add the same repeated number. I have slightly modified code as

HTML Code: 

where I don’t have any condition and unique is not needed anymore. Issue is when ever I add new column the last column is showing as unique rather than adding data like previous columns.
Any idea of where I am going wrong please?

Thanks once again

Do you mean like this?

Please Login or Register  to view this content.

Perfect. You are star

Thanks a lot again