ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multi-Level Subtotals (https://www.excelbanter.com/excel-discussion-misc-queries/142424-multi-level-subtotals.html)

Douglas Eckert

Multi-Level Subtotals
 
I need to display the left-hand column field name in my sub-tota rows.
Sub-totals are focused on column B. For instance, I need to display the name
of a worker (in column A) next to the field name of each kind of work they
did as shown in column B - ( work codes are sub-totaled in column B). The
sub-totals are displayed in column B, but not the names of who did the work.
My final list needs to show the worker's names in column A and the five-digit
work-type codes (sub-total field) and the summed count of work in Column C.
(A pivot table is no good here because I must produce a list in columns as
the final product. I will match that list (table) with another table in MS
Access, to produce the final report.


All times are GMT +1. The time now is 03:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com