282,581 views
37 votes
37 votes
Spreadsheet feature that can be used to arrange data from highest to lowest based on average


User Jhui
by
2.8k points

1 Answer

22 votes
22 votes

Answer:

RANK.AVG

Step-by-step explanation:

Required

Arrange data in descending order based on average

The feature to do this is to use the RANK.AVG() function.

By default, the function will return the ranks of the selected data in descending order (i.e. from highest to lowest); though, the sort order can be changed to ascending order.

The syntax is:

=RANK.AVG (number, ref, [order])

Where

number
\to The number to use as rank

ref
\to The cell range

order
\to 0 represents descending order while 1 represents ascending order

User Mastak
by
3.2k points