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...