View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sakballs sakballs is offline
external usenet poster
 
Posts: 1
Default 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%