Forum Discussion
Overall/Final Rank from multiple ranked lists
Lets say I have from 25 sources of the same lists of data of items that have been ranked. The data list has 5 items ranked from position 1 (best) to position 5 (worst). How do I create an overall r...
You can use AVERAGE() or MEDIAN() or MODE() to calculate a value for each item.
I would suggest either MEDIAN() or MODE().
Detlef_Lewin I tried few of these and The MEDIAN and AVERAGE gives more accurate results and better suited. Thanks.