This FAQ covers 3 common question groups about RANK.AVG, including errors, unexpected results, and filling formulas across multiple cells.
FAQ
What should I do if RANK.AVG returns an error value?
- Check whether the arguments used in the formula are numeric.
- Confirm that the referenced range does not contain text-formatted numbers that affect calculation.
- Review the parentheses, separators, and argument order in the formula.
Why does the RANK.AVG result differ from what I expected?
- Check whether the referenced range is complete.
- Confirm that the ranking order argument is set correctly for your intended sort direction.
- If duplicate values exist, remember that this function returns the average rank for ties.
How do I use RANK.AVG in multiple cells at once?
- Enter and confirm the formula in the first cell.
- Drag the fill handle downward, or copy and paste the formula into the target range.
- Check whether the copied references should be locked as absolute references.
Glossary
| Term | Definition |
|---|---|
| RANK.AVG | A function that returns the rank of a number within a list of numbers and returns the average rank when ties exist. |
| Argument | A value, cell reference, or range reference used inside a function. |
| Reference range | The group of cells that a function uses for comparison or calculation. |