Home › Functions › Statistical › =RANK.AVG()
Statistical Excel 2010 ◉ 19 views

=RANK.AVG()

Returns the rank of a number in a list of numbers: its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016Excel Web App
=RANK.AVG(number,ref,[order])
Hover argument names in the table for details.
Output typeNumber
Popularity25 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =RANK.AVG() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
📥 Download RANK.AVG.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
number Number Required The number whose rank you want to find.
ref Range Required An array of, or a reference to, a list of numbers. Nonnumeric values in Ref are ignored.
order Number Optional A number specifying how to rank number.

▣ Examples

▦ Data
CellValue
A2 Day
B2 Temp (F)
A3 7/1/2011
B3 89
A4 7/2/2011
B4 88
A5 7/3/2011
B5 92
A6 7/4/2011
B6 101
A7 7/5/2011
B7 94
A8 7/6/2011
B8 97
A9 7/7/2011
B9 95
A10 Day
B10 Temp (F)
A11 7/1/2011
B11 89
A12 7/2/2011
B12 88
A13 7/3/2011
B13 92
A14 7/4/2011
B14 101
A15 7/5/2011
B15 94
A16 7/6/2011
B16 97
A17 7/7/2011
B17 95
Finds the rank (the position) of the value 94 in the cell range B2:B8. In this case, 7/5/11, when the temperature reached 94, was the 4th hottest day of the days listed. =RANK.AVG(94,B2:B8)
Result: 4

§ Remarks

  • If Order is 0 (zero) or omitted, Excel ranks number as if ref were a list sorted in descending order.
  • If Order is any nonzero value, Excel ranks number as if ref were a list sorted in ascending order.

✦ Tips

  • If Order is 0 (zero) or omitted, Excel ranks number as if ref were a list sorted in descending order.
  • If Order is any nonzero value, Excel ranks number as if ref were a list sorted in ascending order.

⇄ Related Functions

=LARGE() Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score. =PERCENTRANK.INC() Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. =RANK() Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.) For more information about the new functions, see RANK.AVG function and RANK.EQ function. =RANK.EQ() Returns the rank of a number in a list of numbers. Its size is relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned. If you were to sort the list, the rank of the number would be its position.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.