Need help/direction with this Excel problem.

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)
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!