Forum Discussion
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...
By the way, if it's really average of each row, and then sorted, that you want, all you'd need to do with that workbook I sent is change the formula under the Weighted heading to read =AVERAGE(B2:D2) and copy that down. The SORT function on the next page would still work.
However, that doesn't give you a way to weigh the relative importance of the three columns.