Manoj_Mishra
New Member
- Joined
- Oct 6, 2017
- Messages
- 1
I have an excel sheet with multiple columns (A,B,C,D,E,F) below
[TABLE="width: 646"]
<tbody>[TR]
[TD]Date Worked[/TD]
[TD]Project[/TD]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]Service Deliver[/TD]
[TD]Worked Hours[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]No Work[/TD]
[TD]2.0[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]No Work[/TD]
[TD]2.0[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]Quality Check[/TD]
[TD]2.5
[/TD]
[/TR]
[TR]
[TD] I want to remove the duplicates rows by grouping data columns (A,B,C,D,E,) but summing the values in the G column corresponding to the repeating rows as shown in below image.
[TABLE="width: 646"]
<tbody>[TR]
[TD]Date Worked[/TD]
[TD]Project[/TD]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]Service Deliver[/TD]
[TD]Worked Hours[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]Quality Check[/TD]
[TD]7.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]No Work[/TD]
[TD]2.0[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]Quality Check[/TD]
[TD]5.0[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]No Work[/TD]
[TD]4.5[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col></colgroup>[/TABLE]
[TABLE="width: 646"]
<tbody>[TR]
[TD]Date Worked[/TD]
[TD]Project[/TD]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]Service Deliver[/TD]
[TD]Worked Hours[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]No Work[/TD]
[TD]2.0[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]No Work[/TD]
[TD]2.0[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]Quality Check[/TD]
[TD]2.5
[/TD]
[/TR]
[TR]
[TD] I want to remove the duplicates rows by grouping data columns (A,B,C,D,E,) but summing the values in the G column corresponding to the repeating rows as shown in below image.
[TABLE="width: 646"]
<tbody>[TR]
[TD]Date Worked[/TD]
[TD]Project[/TD]
[TD]Name[/TD]
[TD]Code[/TD]
[TD]Service Deliver[/TD]
[TD]Worked Hours[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]Quality Check[/TD]
[TD]7.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]Ram[/TD]
[TD]123[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Beta[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]No Work[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]No Work[/TD]
[TD]2.0[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Gama[/TD]
[TD]ABC[/TD]
[TD]932[/TD]
[TD]Quality Check[/TD]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]Quality Check[/TD]
[TD]5.0[/TD]
[/TR]
[TR]
[TD]9/14/2017[/TD]
[TD]Alfa[/TD]
[TD]XYZ[/TD]
[TD]579[/TD]
[TD]No Work[/TD]
[TD]4.5[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col></colgroup>[/TABLE]