| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create percentages for the combined rows?
I have a workbook with data in columns A + B. Currently, I have the info in
columns A + B sorted lowest to highest. Now, I need to display in column C how all of the rows compare to each other in a percentage. For example, A B C 1. 12 1 10% 2. 25 4 20% 3. 38 8 30% 4. 41 12 40% 5. 57 23 50% 6. 61 29 60% 7. 79 37 70% 8. 83 39 80% 9. 90 45 90% 10. 95 55 100% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a combined Cluster and Stacked Column Chart? | Charts and Charting in Excel | |||
| How do I create a combined 'cluster' and 'stacked' column chart? | Charts and Charting in Excel | |||
| How do I create chart that show percentages for 1 and 0's? | Excel Worksheet Functions | |||
| I need to create an array formula combined with a countif | Excel Worksheet Functions | |||
| countif for only visible rows when combined with autofilter - possible? | Excel Discussion (Misc queries) | |||
Threaded Mode
