Modifying the Calculations In Excel's Subtotal Feature
While Excel’s Subtotal feature can be a great way of summarizing data and creating drill-down reports, you are limited to using one of the tool’s eleven summarizing functions. Suppose you find a situation where you would like to use Subtotal, but the calculation you require – calculating a median, for example – is not one of the eleven available in Subtotal. In this tip, you will learn how to use a little trickery to “persuade” Subtotal to work just the way you want it to.