| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to programatically control a 3D-sum?
BTW,
The reason for the "..(OFFSET(.." was to create a function that was "fill-down/right"-able. With "OFFSET" I can do this with a supporting column, and get a quite compact writing. A pondered to use a "ROW()" construct to allow for "fill-down", and it works. But if you want to have it working both for "fill-down" and "fill-right" it gets a little bit cumbersome. So therefore I used the "OFFSET" solution. (Is there an even better solution, perhaps?) Best regards / Ake |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| API for MS Chart Control | Charts and Charting in Excel | |||
| Variable control tip text | Excel Discussion (Misc queries) | |||
| calendar control - formatting | Excel Discussion (Misc queries) | |||
| Copying list-box control | Excel Discussion (Misc queries) | |||
Hybrid Mode
