Forum Discussion
How do I weigh ranking based on value size
Hi All
Im trying to rank some numbers in excel and it works fine so far. However it is not depicting differences between values as i would like:
Ranked table is on top with the following formula:
=RANK(C17;$C$17:$C$23;1) / =RANK(D17;$D$17:$D$23;1)
| onboardings ranking |
| 7 |
| 6 |
| 5 |
| 4 |
| 1 |
| 3 |
| 2 |
| onboardings data |
| 1013 |
| 248 |
| 222 |
| 139 |
| 14 |
| 51 |
| 46 |
Now as you can see it ranks just fine, but the difference between the highest in onboardings ranking (7) and the next highest (6) is just marginal. I would like the formula to be able to give some space in between, maybe say more like 8 or 9 and skip in between.
How can i define the Rank starting at 10 and be variable in between?
Thanks for the help
Hi Hans
Problem is im trying to create a matrix like this:
with 2 of these tables and some values are so great or differ so much that it distort the entire matrix
Here is an example of a chart using the actual values, but with logarithmic axes.
Have you tried using a logarithmic scale for both axes?
Why not use the values themselves? They perfectly represent the spacing.
