RANKAVG
Returns the rank of a number in a list. If multiple values have the same rank, the average rank is returned.
| Category | Statistical |
| Syntax | RANKAVG(number, ref, [order]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
number | Required | The number whose rank you want to find. |
ref | Required | The range or array of numbers to rank against. |
order | Optional | 0 (default) for descending rank, non-zero for ascending rank. |
Example
RANKAVG(A1:A10)
Auto-generated from the EngCanvas function registry.