I'm making a contest and I'm using different variables to rank each player. The final score is determined by the sum of each variable.
However, I'm having trouble using the rank function, because I want to see the min value (for all values that fit in the same range) and the next value displayed must be the consecutive one.
For example, in column D I have 1, 2, 3, 3, 3 and then it jumps on to 6. I need this to be 1, 2, 3, 3, 3, 4, 4, 4, 5... and so on. Is there a way to achieve this? I've tried using all of the rank modes but apparently it's not possible using this function.
I need all of the variables to be ranked at the same time so, I can´t use the above/before functions.
Only way I can think of to do this would be to create a concatenated list of distinct values (ordered by value), then get the position of the value in that list using the MATCH function, something like ...
Only way I can think of to do this would be to create a concatenated list of distinct values (ordered by value), then get the position of the value in that list using the MATCH function, something like ...
