Returns the rank of a number relative to other numbers in a range. Assigns an average rank to any duplicates.
Sample Usage
RANKAVG([Units Sold]1,[Units Sold]:[Units Sold],1)
Syntax
RANKAVG(
-
number
-
range
-
[
order]
-
number—The number to rank.
-
range—The group of cells to evaluate.
-
order—[optional]The arrangement to use to evaluate the range.