| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 level subtotal result weird
refer to below sample.
I do a subtotal on column ID1, then subtotal again on ID2. the result looks weird: row 11 shows b total and row 12 shows y total, it should be the other way round. same apply to row 16 (c total) and row 17 (y total) etc. pls advice. thanks ! ID1 ID2 amt a x 1 b x 2 b x 3 b x 4 b y 5 b y 6 c x 7 c y 8 d x 9 d y 10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| level buttons not visible for subtotal | Excel Discussion (Misc queries) | |||
| subtotals showing 0 in summary level// 2 subtotal levels | Excel Discussion (Misc queries) | |||
| Unhide column based on subtotal level open. | Excel Discussion (Misc queries) | |||
| copy visble cells at the subtotal level | Excel Worksheet Functions | |||
| Array formula weird result | Excel Discussion (Misc queries) | |||
Threaded Mode
