SOLVED

Help Needed on Formula - Sum Qty when a Duplicate Name Exists

%3CLINGO-SUB%20id%3D%22lingo-sub-1506420%22%20slang%3D%22en-US%22%3EHelp%20Needed%20on%20Formula%20-%20Sum%20Qty%20when%20a%20Duplicate%20Name%20Exists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506420%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20for%20help.%20Have%20a%20list%20of%20Employee%20%23s%20and%20when%20there%20is%20a%20duplicate%2C%20I%20would%20like%20to%20sum%20the%20hours%20in%20Column%20K%20and%20return%20the%20total%20in%20a%20New%20Column.%20all%20the%20better%20if%20it%20can%20also%20delete%20one%20of%20the%20duplicate%20rows%20in%20doing%20so%2C%20so%20I%20am%20left%20with%20a%20Total%20that%20corresponds%20to%20the%20one%20employee.%20Attached%20is%20a%20data%20sample%20and%20desired%20outcome%20example.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1506420%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1506564%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Needed%20on%20Formula%20-%20Sum%20Qty%20when%20a%20Duplicate%20Name%20Exists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506564%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721344%22%20target%3D%22_blank%22%3E%40emilyexcel%3C%2FA%3E%26nbsp%3BPlease%20find%20attached%20solution%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20satisfied%20with%20the%20solution%20do%20mark%20this%20solution%20as%20best%20and%20official%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1506573%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Needed%20on%20Formula%20-%20Sum%20Qty%20when%20a%20Duplicate%20Name%20Exists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506573%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721344%22%20target%3D%22_blank%22%3E%40emilyexcel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20delete%20the%20empty%20columns%20from%20your%20data%20set%2C%20you%20may%20insert%20a%20Pivot%20Table%20to%20get%20the%20data%20in%20desired%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERefer%20to%20the%20attached%20and%20look%20at%20the%20sheet%20called%20%22Pivot%20Table%22%20for%20more%20details.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1506591%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Needed%20on%20Formula%20-%20Sum%20Qty%20when%20a%20Duplicate%20Name%20Exists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506591%22%20slang%3D%22en-US%22%3ENailed%20it--thank%20you!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1506641%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Needed%20on%20Formula%20-%20Sum%20Qty%20when%20a%20Duplicate%20Name%20Exists%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506641%22%20slang%3D%22en-US%22%3E%3CP%3EYou're%20welcome%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721344%22%20target%3D%22_blank%22%3E%40emilyexcel%3C%2FA%3E!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi There, 

 

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. 

4 Replies
Highlighted

@emilyexcel Please find attached solution

 

If you are satisfied with the solution do mark this solution as best and official solution.

Highlighted
Best Response confirmed by emilyexcel (New Contributor)
Solution

@emilyexcel 

If you delete the empty columns from your data set, you may insert a Pivot Table to get the data in desired format.

 

Refer to the attached and look at the sheet called "Pivot Table" for more details.

 

 

Highlighted
Nailed it--thank you!!
Highlighted