LARGE in Collabora Office: Return Ranked High Values and Handle Ties

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: online and mobile deployments are not inferred from desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independent calculations; no native Collabora test was performed.

=LARGE(data;rank)

data is the source range and rank is the requested position. Rank 1 asks for the largest value. Repeated values occupy repeated positions; this is not a distinct-value ranking. Collabora explicitly documents that text and empty cells within the data range are ignored.

The source also documents an array-valued rank argument, in which case LARGE becomes an array function. The ordinary scalar examples below require no rank array. English function names and semicolon separators are used throughout.

Enter numeric 6, 11, 8, 11, 17, 5 in A2:A7. Put ranks 1, 2, 3, 4, 5, 6 in C2:C7 and fill this formula down from D2:

=LARGE($A$2:$A$7;C2)

Expected values are 17, 11, 11, 8, 6, 5. The absolute references keep the source range fixed while C2 advances to the next rank. The second and third positions both return 11 because the source contains two separate observations of that value.

=LARGE(A2:A7;1) agrees with MAX for this numeric range, while rank 6 returns the minimum 5. This is a value sequence, not a rearrangement of the original rows.

=LARGE(A2:A7;1)+LARGE(A2:A7;2)+LARGE(A2:A7;3)

Expected result: 39, from 17+11+11. Keeping only distinct values would instead give 17+11+8=36. The difference is meaningful when repeated measurements represent separate tasks.

If the 17 in A6 is changed to numeric 27, the expected top-three total becomes 49. Restore 17 before continuing the remaining controls so all later results use the stated original dataset.

The second-largest value is 11. Selecting every source value greater than or equal to that cutoff includes three observations: 11, 11 and 17.

=COUNTIF(A2:A7;">="&LARGE(A2:A7;2))

Expected result: 3. A threshold defined by rank 2 does not guarantee exactly two returned records when values tie. If exactly two records are required, define a separate tie-breaker, such as a stable unique record key, rather than silently discarding an arbitrary tied row.

The COUNTIF check measures how many numeric observations satisfy the cutoff. LARGE itself returns only the cutoff value, not a list of row identities.

Put ranks 1, 3, 6 in F2:F4. Using the deployment’s array-formula entry workflow, enter this as an array formula for a corresponding three-cell vertical result:

=LARGE(A2:A7;F2:F4)

Expected values are 17, 11, 5. The Collabora function section explicitly supports a rank array. The required array-entry procedure and automatic-expansion behavior should be checked in the target client; this guide does not assume that every online deployment spills the formula identically.

A scalar fallback is to fill =LARGE($A$2:$A$7;F2) down three rows. It requests the same positions without relying on the rank-array entry workflow.

In H2:H6 enter numeric -4, text Pending, numeric 0, a genuinely empty cell, and numeric 7. Ranks 1 through 3 have expected values 7, 0, -4. The text and empty cell are excluded, while zero remains an observation.

Using SMALL on the same numeric participants reverses the ordered-position direction. Signed value and absolute magnitude are different ranking questions; 7 ranks above -4 even though both are numeric.

Keep scalar ranks as positive integers within the numeric participant count for these examples. The dedicated source does not establish a complete fractional-rank, zero-rank, out-of-range or error-containing matrix; specific error labels are not imported from Excel.

The source’s OpenDocument 1.2 standards note describes formula standardization, not the first Collabora release or a universal compatibility guarantee. Preserve complete source rows when sorting outside the formula so values remain attached to their original records.

• Collabora Office 26.04: LARGE.
• Editorial testing standards.

The function-specific Collabora documentation was reviewed. Worked results are independent arithmetic or documented type-rule controls, not captured output from the application. Client-specific entry procedures and the boundaries identified above remain subject to native verification.