Contact
12 programs
Explore the site

RANK Function in Apple Numbers: Ties, Ascending and Descending

Statistical Intermediate Apple Numbers

Rank values in Apple Numbers with tied-score examples, ascending and descending choices, exact syntax and error handling.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked

Quick answer: =RANK(B2,B2:B9,0) tells you where the numeric value in B2 stands among the values in B2:B9, with the largest number in first place. If the values are the scores in the practice table below, the result is 1; another 94 ties for first. Apple’s RANK uses competition ranks: tied observations receive the same rank and skip later rank positions. [A1, C1]

RANK answers where a given observed value stands. Use LARGE or SMALL when you need the value occupying a particular ordered position instead. This distinction matters if scores are tied or a requested value is not actually present in the collection. [A1, A2, A3]

Exact official syntax and argument order

=RANK(value, value-set, ranking-order)
Argument Required? Apple-documented meaning
value Yes One number, date/time, or duration to rank.
value-set Yes A collection of values of the same type as value; values in the set must have the same type as one another.
ranking-order No 0, FALSE, or omission ranks largest first; 1 or TRUE ranks smallest first.

The argument order is value first, collection second, direction third. If you omit direction, descending order is the Apple-documented default. Apple only documents the selectors 0/FALSE and 1/TRUE; do not assume another numeric selector is portable from Excel. The function requires the supplied value to occur in value-set; otherwise Apple documents an error, without specifying the displayed error code in this paragraph. [A1]

Platform, version, locale and table references

These examples target the English Apple Formulas and Functions Help, documentation edition 15.4, consulted on 2026-10-12. The 15.4 label is the version of the cited help pages, not a claim that this function first appeared in Numbers 15.4 or works unchanged in every older release. Apple’s current Numbers release notes describe Numbers 15.4 for Mac, including a macOS 26 requirement; check the specific application/device release when compatibility with older installations matters. [P1, P3]

Start with one Numbers table so a reference such as B2:B9 unambiguously means cells in that table. For references in another table Numbers uses a double-colon form such as Table 2::B2; across sheets, Apple documents a form such as Sheet 2::Table 1::C2:G2. In real workbooks, selecting the target cells with the formula editor is safer than pasting Excel-style Sheet1!A1 references. [P2]

Formula argument separators follow the decimal separator: Apple’s English examples use commas (=FUNCTION(value,range)), but Apple instructs authors using a decimal comma to type semicolons between function arguments. A range colon (B2:B9) remains a range colon. Capitalizing the function name is optional. Enter ordinary numerals as numeric values, not text with embedded units. [P1]

Validation labels used below: Apple-documented expected = Apple publishes the exact example or behavior; independently calculated expected = arithmetic performed outside Numbers on the data shown; native observed would require running a real Numbers installation, which was not available. No native screenshot or execution is claimed.

Build a reproducible scoring table

  1. Create a blank Numbers table with at least nine rows and two columns. Make row 1 the header: A1: Learner and B1: Score. Keep all eight scores as actual numbers.
  2. Enter the data exactly as shown. Place each formula in a separate empty cell outside B2:B9 (for example D2); do not put a formula in the input range and overwrite a score.
  3. In D2 enter =RANK(B2,B2:B9,0). Repeat in other result cells, changing the first argument as indicated. All example results are expected values from arithmetic or Apple’s documentation, not observations from Numbers.
Row A: Learner B: Score
2 Ada 94
3 Ben 88
4 Cleo 88
5 Dev 76
6 Emi 65
7 Finn 94
8 Gia 51
9 Hugo 76

Descending order for independent checking: 94, 94, 88, 88, 76, 76, 65, 51. The ranked positions are 1, 1, 3, 3, 5, 5, 7, 8, respectively. Equal numbers have equal rank, but still occupy positions, so there is no rank 2 or 4 in this example. [A1, C1]

Paste into an empty result cell Independently calculated expected result Why
=RANK(B2,B2:B9,0) 1 Ada’s 94 is tied for the highest score.
=RANK(B3,B2:B9,0) 3 Two 94s come before 88; both 88s receive 3.
=RANK(B5,B2:B9) 5 Omitting direction means largest first; four scores are higher than 76.
=RANK(B6,B2:B9,0) 7 Six observations are above 65.
=RANK(B8,B2:B9,1) 1 Gia’s 51 is the smallest score.
=RANK(B2,B2:B9,TRUE) 7 94 is tied in positions 7 and 8 when smallest is ranked first.
=RANK(90,B2:B9,0) Error expected Apple explicitly requires an exact match somewhere in the collection; 90 is absent.

Why the results follow: descending RANK(v) is 1 + (number of entries strictly greater than v). Ascending RANK(v) is 1 + (number strictly less than v). This is an independent mathematical explanation of the Apple-documented examples and tie policy; it is not an assertion about the internal implementation. [A1, C1]

Apple-published example: verify a different data layout

Apple supplies a 20-score table over A1:E4 and documents these formula results: =RANK(30,A1:E4,1) returns 1, =RANK(92,A1:E4,0) returns 2, and =RANK(91,A1:E4,0) returns 4. Two students score 92, so the next lower score follows ranks 2 and 2 at rank 4. These are Apple-documented expected results, not values observed in our runtime. [A1]

If you reproduce that table, first copy all 20 source values from Apple’s help article. Do not apply the A1:E4 examples to the separate eight-score practice table above; the range contents are different. [A1]

Advanced uses: tied leaderboards and reading ranks correctly

Ties: In a sales leaderboard where two salespeople each have the top sale amount, both can display rank 1. The next amount is rank 3—not rank 2. RANK does not calculate a dense rank of distinct values. [A1]

Lowest-first rankings: In a race-time table, lower duration values might be better. Apple’s RANK accepts duration values, provided every value in the ranked collection is of the same type; pass 1 for smallest first. Because duration formatting, text importing and mixed value types depend on your workbook, create a small real-Numbers test before applying the formula to competition results. [A1]

Related order-statistic cross-checks: With the eight numeric scores above, =LARGE(B2:B9,3) has independently calculated expected value 88, and =SMALL(B2:B9,2) has independently calculated expected value 65. These identify the third-largest and second-smallest observations, which is a different question from an individual person’s RANK. [A2, A3, C1]

Cross-table input: If your scoreboard lives in a separate table, use the Numbers formula editor to select the value and full comparison range. Verify that the resulting reference points to the intended sheet and table. Avoid a partially selected range or a self-referential result column. [P2]

Errors, limitations and troubleshooting

Symptom Inspect this first Evidence level
Error when ranking a value not present in the set Apple requires value to match a member of value-set; check exact numbers and imported data. Explicit in Apple’s RANK documentation [A1].
An unexpected skipped rank Duplicate observations produce tied competition ranks; count observations, not distinct values. Explicit Apple examples [A1].
Rank 1 is the smallest score, not the largest Third argument is likely 1/TRUE; use 0 or omit it for largest first. Explicit Apple syntax [A1].
Numbers rejects mixed scores, dates or durations Apple requires a collection of one value type matching the ranked value. Convert your data consistently first. Explicit Apple type rule [A1].
Formula after copying compares a different group Inspect the selected range and reference preservation in the Formula Editor. Workbook-specific diagnostic; not natively tested [P2].
Pasted formula from Excel fails Confirm comma/semicolon conventions and convert Excel Sheet!A1 references to Numbers cell selections. Apple locale/reference documentation [P1, P2].

Unestablished behavior: This review does not assert a specific error code, automatic coercion of text numbers, rounding of a nonbinary ranking-order value, or identical support in historical releases. Those require additional official evidence or real Numbers execution.

Compatibility: Apple Numbers vs Microsoft Excel

Aspect Apple Numbers Microsoft Excel
Function name RANK(value,value-set,[ranking-order]) Modern Excel documents RANK.EQ(number,ref,[order]); legacy RANK remains available for compatibility.
Default ranking direction Descending; largest is rank 1. Descending when order omitted or zero.
Ties Tied values share a rank, and following ranks may skip. RANK.EQ shares ranks and skips later positions for ties.
Allowed ranked value types Apple explicitly documents numbers, date/time and durations, with homogeneous sets. The cited Excel RANK.EQ documentation defines a number and a reference to numbers; do not infer identical duration handling.
Absent lookup value Apple explicitly documents an error if value is not in the collection. The cited Excel article does not establish a matching Apple-style requirement; verify separately rather than assuming parity.
Nonzero direction Apple documents 1/TRUE for ascending. Excel documents any nonzero order for ascending; don’t transfer that broader guarantee to Numbers.

The Excel statements come from Microsoft, not from Apple and are included solely to help when migrating spreadsheets. [X1, X2]

FAQ

Does rank 1 always mean the largest number? No. It means the largest when the optional direction is omitted, 0, or FALSE; 1/TRUE makes the smallest rank 1. [A1]

Why does my list skip rank 2? Two entries tied at rank 1 occupy the first two positions; the next lower entry receives rank 3. [A1]

Can I rank a value that isn’t in the data? Apple says no: the specified value must match an entry in the set or the function returns an error. [A1]

Can I rank dates or durations? Apple lists both as accepted value types, but the compared set must be homogeneous and match the type of the ranked value. Native verification is still needed for your particular workbook and installed release. [A1]

Native validation: These results were checked against official documentation and independent arithmetic, without running Apple Numbers or capturing native screenshots.