The RANK.
AVG function in Excel, Google Sheets, and other spreadsheet programs
is used to determine the rank of a number within a list of numbers. Unlike the
[Link] function, which gives the same rank to tied values, [Link] assigns
the average rank to tied values.
The basic syntax for the [Link] function is:
=[Link](number, ref, [order])
Arguments
number: This is the required value you want to find the rank for. It can be
a number or a reference to a cell containing a number.
ref: This is the required range of cells that contains the list of numbers
you are ranking against. It must be an array or a reference to an array of
numeric values.
[order]: This is an optional argument that specifies how to rank the
numbers.
o If you enter 0 (or omit the argument), the function ranks the
numbers in descending order (the highest value gets a rank of 1).
o If you enter any non-zero value (e.g., 1), the function ranks the
numbers in ascending order (the smallest value gets a rank of 1).
The [Link] function in Excel, Google Sheets, and other spreadsheet programs
is used to determine the rank of a number within a list of numbers. Unlike the
[Link] function, which gives the same rank to tied values, [Link] assigns
the average rank to tied values.
The basic syntax for the [Link] function is:
=[Link](number, ref, [order])
Arguments
number: This is the required value you want to find the rank for. It can be
a number or a reference to a cell containing a number.
ref: This is the required range of cells that contains the list of numbers
you are ranking against. It must be an array or a reference to an array of
numeric values.
[order]: This is an optional argument that specifies how to rank the
numbers.
o If you enter 0 (or omit the argument), the function ranks the
numbers in descending order (the highest value gets a rank of 1).
o If you enter any non-zero value (e.g., 1), the function ranks the
numbers in ascending order (the smallest value gets a rank of 1).
Example
Imagine you have a list of sales figures in cells B2 to B8 and you want to rank
them. Two employees have the same sales figure of $150.
=[Link](B2, B2:B8, 0)
In this case, if the two employees with $150 would normally be ranked 3rd and
4th, the [Link] function will assign a rank of 3.5 to both of them.