Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to create a macro to subtotal only data that is duplicated.
For instance, the current subtotal function subtotals all lines, even those with 1 line item. Sorry if this is confusing, maybe the example below will help: 1 2 2 1 2 1 The current subtotal function, if applied above will do the following: 1 2 1 subtotal 2 2 1 2 1 2 subtotal 2 I would like for it to skip subtotaling if there is only one item and only do it for duplicate items therefore resulting in: 1 2 2 1 2 1 2 subtotal 2 Any help you can provide is much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional subtotal | Excel Discussion (Misc queries) | |||
sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
Conditional SUBTOTAL | Excel Discussion (Misc queries) | |||
macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
Conditional SUBTOTAL | Excel Discussion (Misc queries) |