| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed with a changing denominator for each grouping
I have numerous groupings of the following information. I'm trying to create
a formula or macro that will calculate the allocation (part/whole) by automatically updating the denominator based on where the next blank line is, signifying the next group, and subtracting one (to where the "over all" line is). The next group would automatically use the new denominator. I don't want to have to manually change the equation for each group. EQUITY $310,481 98% FIXED INCOME $- 0% CASH EQUIVALENTS $5,644 2% CASH $- 0% OVER ALL $316,125 100% EQUITY $1,153,192 FIXED INCOME $871,634 CASH EQUIVALENTS $22,972 CASH $3,598 OVER ALL $2,051,396 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to protect sheet allowing grouping and ungrouping but alsoallowing changing colour of specific cells | Excel Discussion (Misc queries) | |||
| Is there a formula to calculate the least common denominator? | Excel Worksheet Functions | |||
| VB Script Code needed for Grouping Rows | Excel Discussion (Misc queries) | |||
| changing year grouping in pivot table | Excel Discussion (Misc queries) | |||
| How to cause the value in the denominator change with changing row | Excel Discussion (Misc queries) | |||
Threaded Mode
