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)

--
Regards,

OssieMac


"sakballs" wrote:

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%