LARGE Function in Apple Numbers: Top-N Values and Ties

=LARGE(value-set, ranking)

Both arguments are mandatory. No default ranking is documented. With ten values, ranking=1 returns the largest and ranking=10 returns the smallest. Apple’s documentation also notes that if you reference noncontiguous source ranges, you enclose their value set in curly brackets; because the precise punctuation of a complex assembled reference depends on the formula editor and locale, that specialized form is a case requiring native testing rather than an invented cut-and-paste example here. [A1]

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.

1. Create a Numbers table with row 1 as the header. Enter A1: Order, B1: Day, and C1: Amount. Make enough rows to reach row 11.
2. Enter the following numeric amounts in C2:C11, without typing the currency symbol into the data text. A currency number format can be applied after entering numbers.
3. In a separate empty result cell, enter =LARGE(C2:C11,3). Do not put the formula inside C2:C11, where it would overwrite one of the source observations.
4. For independent checking, sort the input values conceptually (no actual Numbers sort is required) to get: 45, 45, 31, 31, 22, 22, 18, 14, 12, 5.

Independent validation: each expected numeric result is the element at the stated 1-based position in the sorted ten-number list. This is an independent calculation, not an observed Numbers output. The out-of-range row is a documentation-based expected invalid condition, not a tested error code. [A1, C1]

Apple’s help page uses a table with 20 cumulative test scores in A1:E4. Apple explicitly documents that =LARGE(A1:E4,1) yields 100; positions 2 and 3 both yield 92; position 6 yields 86. Those values come from Apple’s published example, not from our ten-row practice fixture, so don’t interchange their ranges or expected results. [A1]

Finding a top-three cutoff: =LARGE(C2:C11,3) returns 31 in our example. If you want a threshold for the three highest observations, it is 31. Two observations tie at 45, so the third is 31. If instead you need the third distinct amount, LARGE alone does not give it: the descending distinct values are 45, 31, 22, 18, 14, 12, 5. This distinct-value distinction is arithmetic, not an assertion that Numbers has an automatic deduplication option inside LARGE. [A1, C1]

Counting repeated top amounts: =LARGE(C2:C11,2) still returns 45. Do not describe that as the second-highest distinct sale. If multiple rows have the top value, LARGE returns only a value and cannot identify which matching row to choose; selecting records requires separate lookup/filter logic and explicit tie handling. [A1]

Returning the bottom value via the last position: the numeric fixture has ten entries, and =LARGE(C2:C11,10) equals 5. With a numeric range, =LARGE(C2:C11,COUNT(C2:C11)) also corresponds to the last eligible position. Do not transfer that numeric-count shortcut blindly to date/time or duration data, where type and count semantics must be checked. [A1, C1]

Dates and durations: Apple’s LARGE page explicitly includes dates/times and duration values in the accepted value-set types, provided they are homogeneous. This guide intentionally does not prescribe formatting-specific expected date or duration displays, because their presentation and native handling in the target spreadsheet were not tested. [A1]

Noncontiguous collections: Apple’s own note specifies enclosing a noncontiguous set in braces; use the Formula Editor to construct and validate this with actual referenced cells. Avoid guessing a delimiter because a comma used inside a collection might be confused with a locale’s argument separator. [A1, P1]

Do not substitute an Excel-specific #NUM! error code for Numbers without Apple evidence. The high-confidence claim here is only that ranking outside the documented range is invalid. No attempt was made to execute the formula on Mac, iPad, iPhone or the web app.

Excel’s official LARGE documentation uses LARGE(array,k) for the k-th largest numerical data point, with rank 1 returning the largest. Apple’s value-set and ranking have the same two-position structure, but Apple explicitly documents date/time and duration value sets as well; this review does not assert that Excel will accept, interpret or display those values identically. Microsoft’s error notes (including #NUM! for out-of-range k) are specific to Excel, not evidence of a Numbers error code. [A1, X1]

Both sources describe duplicates counting toward ordered positions. For workbooks moved between applications, test the source data types, regional separators, table/sheet references and error behavior natively rather than relying on apparent function-name parity. [A1, X1, P1, P2]

Is LARGE(range,2) the second-largest different number? Not necessarily. If the top value occurs twice, both occupy positions 1 and 2; Apple’s help example demonstrates exactly this behavior. [A1]

Can ranking be omitted? No. Apple’s LARGE syntax requires both the value collection and its numeric ranking; no omitted-argument default is documented. [A1]

How high can ranking go? From 1 to the number of values in the selected homogeneous collection. A higher position is invalid under Apple’s documented constraints. [A1]

What if I need a person’s rank instead of a top value? Use RANK for an observed value’s ordinal standing; LARGE only returns the value at a requested descending position. [A1, A2]

• [A1] Apple — LARGE, help edition 15.4: exact syntax, accepted types, ranking bounds, duplicates, noncontiguous-set note and official 20-score example.
• [A2] Apple — RANK, help edition 15.4: assigns a value’s position in a set.
• [A3] Apple — SMALL, help edition 15.4: selects the lowest-first ordered value.
• [P1] Apple — Function syntax and locale conventions; [P2] Apple — Table references in Numbers; [P3] Apple — Numbers for Mac version history.
• [X1] Microsoft — Excel LARGE: used for cross-compatibility only; Excel’s errors are not presumed to be Numbers errors.
• [C1] Original ten-amount fixture, independently checked by Python sorting/indexing; using the displayed inputs.

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