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