|
|
Subtotals on random lines |
|
|
|
Sometimes you need to subtotal on random lines in your analysis. This
workbook demonstrates a formula based method to achieve this. |
| |
| No VBA used |
| |
| Here's one of the four examples in the
demonstration workbook.
Two of the examples demonstrate how to sub-total towards the bottom of
the page, the other two demonstrate how to sub-total towards the top of the
page.
|
 |
| |
| The formulas use one or some of the following
functions:
|
|
|
|
|
Purpose |
Formula to subtotal analysis at random positions |
|
|
|
|
Download |
subtotals.zip |
|
|
|
|
|
|
