How to create percentages for the combined rows?

  • Thread starter Thread starter sakballs
  • Start date Start date
S

sakballs

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%
 
Looking at your example do I understand your question correctly in that you
want to calculate the percentage that the row represents and that the values
in the cells have nothing to do with the result? If so then the following
assuming that the first cell is A1.

=COUNT(A1:$A$1)/COUNT($A$1:$A$10)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top