RANKAVG Function

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.