Discussion Re: Help Needed on Formula - Sum Qty when a Duplicate Name Exists in Excel
https://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506573#M67897
<P><LI-USER uid="721344"></LI-USER> </P><P>If you delete the empty columns from your data set, you may insert a Pivot Table to get the data in desired format.</P><P> </P><P>Refer to the attached and look at the sheet called "Pivot Table" for more details.</P><P> </P><P> </P>Tue, 07 Jul 2020 17:38:03 GMTSubodh_Tiwari_sktneer2020-07-07T17:38:03ZHelp Needed on Formula - Sum Qty when a Duplicate Name Exists
https://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506420#M67895
<P>Hi There, </P><P> </P><P>Looking for help. Have a list of Employee #s and when there is a duplicate, I would like to sum the hours in Column K and return the total in a New Column. all the better if it can also delete one of the duplicate rows in doing so, so I am left with a Total that corresponds to the one employee. Attached is a data sample and desired outcome example. </P>Tue, 07 Jul 2020 16:53:06 GMThttps://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506420#M67895emilyexcel2020-07-07T16:53:06ZRe: Help Needed on Formula - Sum Qty when a Duplicate Name Exists
https://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506564#M67896
<P><LI-USER uid="721344"></LI-USER> Please find attached solution</P><P> </P><P>If you are satisfied with the solution do mark this solution as best and official solution.</P>Tue, 07 Jul 2020 17:35:04 GMThttps://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506564#M67896DevendraJain2020-07-07T17:35:04ZRe: Help Needed on Formula - Sum Qty when a Duplicate Name Exists
https://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506573#M67897
<P><LI-USER uid="721344"></LI-USER> </P><P>If you delete the empty columns from your data set, you may insert a Pivot Table to get the data in desired format.</P><P> </P><P>Refer to the attached and look at the sheet called "Pivot Table" for more details.</P><P> </P><P> </P>Tue, 07 Jul 2020 17:38:03 GMThttps://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506573#M67897Subodh_Tiwari_sktneer2020-07-07T17:38:03ZRe: Help Needed on Formula - Sum Qty when a Duplicate Name Exists
https://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506591#M67898
Nailed it--thank you!!Tue, 07 Jul 2020 17:44:35 GMThttps://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506591#M67898emilyexcel2020-07-07T17:44:35ZRe: Help Needed on Formula - Sum Qty when a Duplicate Name Exists
https://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506641#M67901
<P>You're welcome <LI-USER uid="721344"></LI-USER>!</P>Tue, 07 Jul 2020 17:58:22 GMThttps://techcommunity.microsoft.com/t5/excel/help-needed-on-formula-sum-qty-when-a-duplicate-name-exists/m-p/1506641#M67901Subodh_Tiwari_sktneer2020-07-07T17:58:22Z