If a user copies the formula D15 into D16, what would the formula read in D16?
2 answers:
You might be interested in
Answer:
RANK.AVG
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 The number to use as rank
ref The cell range
order 0 represents descending order while 1 represents ascending order