Statistical
Excel 2010
◉ 7 views
=PERCENTRANK.EXC()
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016Excel Web App
=PERCENTRANK.EXC(array,x,[significance])
Hover argument names in the table for details.
Output typeNumber
Popularity10 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =PERCENTRANK.EXC() 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)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
array |
Array | Required | The array or range of data with numeric values that defines relative standing |
x |
Number | Required | The value for which you want to know the rank. |
significance |
Number | Optional | A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.EXC uses three digits (0.xxx). |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
1 |
A3 |
2 |
A4 |
3 |
A5 |
6 |
A6 |
6 |
A7 |
6 |
A8 |
7 |
A9 |
8 |
A10 |
9 |
A11 |
1 |
A12 |
2 |
A13 |
3 |
A14 |
6 |
A15 |
6 |
A16 |
6 |
A17 |
7 |
A18 |
8 |
A19 |
9 |
Returns the rank of the value 7 from the array contained in A2:A10.
=PERCENTRANK.EXC(A2:A10, 7)
Result:
0.7
Returns the rank of the value 5.43 in the same array.
=PERCENTRANK.EXC(A2:A10,5.43)
Result:
0.381
Returns the rank of the value 5.43 in the same array, displaying only 1 significant digit in the result (the default is 3).
=PERCENTRANK.EXC(A2:A10,5.43,1)
Result:
0.3
§ Remarks
- If array is empty, PERCENTRANK.EXC returns the #NUM! error value.
- If significance < 1, PERCENTRANK.EXC returns the #NUM! error value.
- If x does not match one of the values in array, PERCENTRANK.EXC interpolates to return the correct percentage rank.
✦ Tips
- If x does not match one of the values in array, PERCENTRANK.EXC interpolates to return the correct percentage rank.
⚠ Common Errors
#NUM!
If array is empty, PERCENTRANK.EXC returns the #NUM! error value. If significance < 1, PERCENTRANK.EXC returns the #NUM! error value.
Fix: آرایه را پر کنید و برای significance عدد 1 یا بیشتر وارد کنید.
💬 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!