| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get the percentage of total for a large data set
When subtotaling a column based on a field change in another column can Excel
also calculate percentages for each value that makes up the sub total. What I realy need are the percentages EXAMPLE NAME1 100 NAME1 100 NAME1 100 NAME1 100 NAME2 300 NAME2 300 DESIRED RESULT NAME1 100 .25 NAME1 100 .25 NAME1 100 .25 NAME1 100 .25 $400 NAME2 300 .5 NAME2 300 .5 $600 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pie Chart - Percentage of a total? | Charts and Charting in Excel | |||
| Calculating Percentage of Total | Excel Worksheet Functions | |||
| Pivot table from CSV data, problem with percentage of total. | Excel Worksheet Functions | |||
| Percentage Discount Total | Excel Discussion (Misc queries) | |||
| show in a excel graphic a total percentage for 5 diff data fiels | Charts and Charting in Excel | |||
Threaded Mode
