| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUBTOTAL - dynamic selection
I have a MS Excel B/S template with the formula =SUBTOTAL(101,[2008]), and
when the cell is selected, a little arrow appears and it allows me to select the SUBTOTAL function (sum, average, min, max, etc). This is brilliant - anyone know how this is achieved? I can't find any macro or indeed any range named 2008. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Subtotal | Excel Discussion (Misc queries) | |||
| Need Help on Dynamic Range Selection | Excel Discussion (Misc queries) | |||
| dynamic selection of cells | New Users to Excel | |||
| Macro - Dynamic cell selection | Excel Discussion (Misc queries) | |||
| Subtotal line selection | Excel Discussion (Misc queries) | |||
Threaded Mode
