Returns the rank of a number relative to other numbers in a range, and 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
Examples
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.