Can I Spreadsheet?
← All functions

RANK.AVG

Supported, behaves as documented

Category: Statistical · Last tested 2026-08-06

Real, executed compatibility results for the RANK.AVG function across Microsoft Excel, Google Sheets, and LibreOffice Calc — verified by actually running it. Syntax and links to each vendor’s official documentation are below.

Support matrix

EngineDocumentedLive-testedVerdict
Excel Yes Not yet n/a
Google Sheets Yes Not yet n/a
LibreOffice Calc Yes Yes (25.8.7.3, 2026-08-06) Supported, behaves as documented

LibreOffice version history

We executed the same test cases under each LibreOffice release to show exactly when RANK.AVG’s support changed — not documentation claims, real results.

LibreOffice versionVerdictTested
24.2.0.3 Supported, behaves as documented 2026-07-19
24.8.7.2 Supported, behaves as documented 2026-07-19
25.2.0.3 Supported, behaves as documented 2026-07-24
25.8.7.3 Supported, behaves as documented 2026-08-06

Executed test cases

LibreOffice Calc 25.8.7.3 (tested 2026-08-06)

FormulaDescriptionResultExpectedVerdict
=RANK.AVG(20,A1:A5) Documented divergence from RANK.EQ: tied values get the AVERAGE of the ranks they would occupy, not the top rank. Per Microsoft's RANK.AVG docs (https://support.microsoft.com/en-us/office/rank-avg-function-bd406a6f-eb38-4d73-aa8e-6d1c3c72e83a): "If more than one value has the same rank, the average rank is returned." 3.5 3.5
The two tied 20s would occupy ranks 3 and 4 (descending); average = (3+4)/2 = 3.5, vs RANK.EQ's 3 on identical data		 Matched
=RANK.AVG(30,A1:A5) With no ties, RANK.AVG matches RANK.EQ exactly 2 2 Matched
=RANK.AVG(20,A1:A5,1) Tie-averaging also applies with the ascending order argument 2.5 2.5
Ascending, the two tied 20s would occupy ranks 2 and 3 (only 10 is smaller); average = 2.5		 Matched

Docs & syntax