Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Make subtotals 100%
My column fields are 'Years'I want in the first column of 2002 every subtotal
number to represent 100%. I then want year 2003 subtotal numbers increase/decrease to show the new percentage e.g. 2002 subtotal 1 [43] [[100%]] subtotal 2 [165] [[100%]] 2003 subtotal 1 [45] [[104.65%]]subtotal 2 [171] [[103.64%]] |
#2
|
|||
|
|||
Try this against a copy of your worksheet.
Do your data|subtotals. But then convert the =subtotal() formulas to values (maybe do the whole worksheet and get rid of the formulas???) Then use the outlining symbols on the left to show only the subtotal lines you want. Then select the "basis" row (2002?). copy it. Then select the remaining data edit|goto|special|visible cells only edit|paste special|check divide. Then do it again for the "basis" row (2002) or just change those all to 1's. Select those cells again (and use edit|goto|special|visible cells only) and format them as percentages. But you have lost the formulas when you do this. JaniceHill wrote: My column fields are 'Years'I want in the first column of 2002 every subtotal number to represent 100%. I then want year 2003 subtotal numbers increase/decrease to show the new percentage e.g. 2002 subtotal 1 [43] [[100%]] subtotal 2 [165] [[100%]] 2003 subtotal 1 [45] [[104.65%]]subtotal 2 [171] [[103.64%]] -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
How to make this plot? | Charts and Charting in Excel | |||
How to I make a decision using excel? | Excel Discussion (Misc queries) | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |