Forum Discussion
Mackenzieparker
Feb 21, 2019Copper Contributor
Excell
Hello, does anyone know how to get the average of multiple rows in order from largest to smallest? For example…Our employees have 3 different categories they get ranked In & we want Excel to categori...
mathetes
Jul 30, 2020Gold Contributor
Here's a workbook that will give you the option of assigning relative weights to the different columns, then will produce a single weighted score for each individual.
The "Sorted" tab then shows the names (with their scores) sorted in descending order by the weighted scores.
It does require the use of the SORT function which is only available in the newest Excel versions.