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...
Hi,
That's not clear what do you mean. You may sort by 3 columns, one level within another (which ones?). You may generated some weighted rank based on 3 cells in each row (what are weights?). Perhaps something else. What is average for rows isn't clear as well.
Perhaps you may to illustrate by screenshort with desired after sorting of your source data result.