How to create percentages for the combined rows?

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%
 
O

OssieMac

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

Top