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