To find duplicate and add total

[mmustkee]

Hi Team,

I have sheet in which we have column "TN" in which we have duplicate values. I need to find out duplicate and then add a total of column "OA" and "OT" of that particular TN and then mention number of TN duplicate in column "Number of TN".

Example is as below for TN = 69

SN	TN	OA	OT	Total	Number of TN
10	69	3	63	354	3
27	69	82	24	354	3
28	69	178	4	354	3

[mmustkee]

Hi Team,

@qui

Please have a look

[atcodedog05 · Accepted solution]

Hi @mmustkee 

Here is how you can do it.

Workflow:

Hope this helps : )

[binuacs · Accepted solution]

@mmustkee 

[Qiu · Accepted solution]

@mmustkee 

The two experts have already responded. 😁

[mmustkee]

Hi,

Thanks a lot for your quick solution.

This worked for the attached table. let me use this to my file scenario and will come back in case.

Thanks a lot.

Thanks,

Mohammad Mustkeem

[atcodedog05]

Happy to help : ) @mmustkee 

Cheers and have a nice day!

[Qiu]

@mmustkee 
Hope I can help next time. thank for the mark. 😁