SOLVED

Need help/direction with this Excel problem.

Copper 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 (Copper 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!
1 best response

Accepted Solutions
best response confirmed by Chasemcguire2 (Copper 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!

View solution in original post