SOLVED

Need help/direction with this Excel problem.

%3CLINGO-SUB%20id%3D%22lingo-sub-3072646%22%20slang%3D%22en-US%22%3ENeed%20help%2Fdirection%20with%20this%20Excel%20problem.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072646%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20pull%20each%20unique%20Client%20Code%20from%20one%20column%20of%20my%20Excel%20sheet%2C%20then%20pulling%20each%20unique%20Service%20Code%20related%20to%20that%20Client%20Code%2C%20and%20then%20finally%20summing%20a%20third%20column%20(Hours)%20for%20each%20unique%20Service%20Code%2FClient%20Code%20combo.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20if%20this%20is%20something%20that%20can%20be%20done%20with%20a%20simple%20formula%20and%20may%20need%20to%20be%20done%20with%20a%20macro%20or%20VBA%3F%20Any%20help%20is%20much%20appreciated.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20Help.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342580i342EEC82E0E0A2B8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Excel%20Help.PNG%22%20alt%3D%22Excel%20Help.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am trying to pull each unique Client Code from one column of my Excel sheet, then pulling each unique Service Code related to that Client Code, and then finally summing a third column (Hours) for each unique Service Code/Client Code combo.

 

I'm not sure if this is something that can be done with a simple formula and may need to be done with a macro or VBA? Any help is much appreciated. Excel Help.PNG

 

2 Replies
best response confirmed by Chasemcguire2 (New Contributor)
Solution
That is very simply done using a Pivot table. Insert, Pivot table, drag both Client code and Service code to the row area in the task pane. Then drag Hours to the sigma region. Done!
Ahhh PivotTables! I can't believe I didn't think of that thank you so much for your help!