PlanMaker RANK.AVG: Average Tie Positions and Rank-Sum Checks

• Introduced: Documented by the PlanMaker 2018 manual; the original introduction release and date are not established.
• Availability: Documented in PlanMaker 2026. This checked version is not a final supported-version endpoint.
• Scope: Current reference belongs to the PlanMaker 2026/NX manual family. FreeOffice and individual mobile-build availability are not established here.
• Checked: October 14, 2026, against the official RANK.AVG reference and historical manual. Examples were independently calculated; no native PlanMaker test was performed.

RANK.AVG(Number, Range [, Ascending])

The PlanMaker reference requires a number and a numeric comparison range. Its optional logical Ascending argument is FALSE or omitted for highest-first and TRUE for lowest-first. Use the documented logical settings rather than an unverified numeric-direction shortcut.

If Number is absent from Range, the documented result is #N/A. Average ranking concerns repeated values already in the group; it is not interpolation for absent values. Brackets show optional syntax and are not typed; the examples follow the English comma convention.

Create AveragePositions, with columns A:J and ten rows available. Put Score in A1, Descending in B1, Ascending in C1 and Best position in D1. Enter 90,70,70,50,50,50,20 in A2:A8.

In B2 enter =RANK.AVG(A2,$A$2:$A$8,FALSE) and fill through B8. In C2 enter =RANK.AVG(A2,$A$2:$A$8,TRUE) and fill through C8. In D2 enter =RANK.EQ(A2,$A$2:$A$8,FALSE) and fill through D8 for a separately documented comparison.

In descending order, the seventies occupy positions two and three, averaging 2.5. The fifties occupy four, five and six, averaging 5. RANK.EQ assigns the best occupied position instead, explaining D’s twos and fours.

In H2 enter =RANK.AVG(70,A2:A8) for 2.5; in H3 enter =RANK.AVG(70,A2:A8,FALSE) for the same result. In H4 use =RANK.AVG(80,A2:A8) for the documented #N/A, since eighty is absent.

Put these controls in J2:J6:

The positions one through seven sum to 28. Replacing each tied block’s positions by their average preserves that total: the two 2.5 ranks still total five, and the three fives still total fifteen. Giving every tied record its best position does not preserve the total, which explains 24 for RANK.EQ.

In E2 enter =B2+C2 and fill through E8. All seven results are 8, or n+1. The ascending and descending average positions complement one another even within tied groups.

For a separate all-tied control, create EqualScores, enter 50,50,50,50 in A2:A5 and put =RANK.AVG(A2,$A$2:$A$5,FALSE) in B2, filling through B5. Each result is 2.5, the average of positions one to four. Their total is ten. All-tied competition ranks would each be one; neither method selects a unique winning record.

These invariants assume every row being summarized is ranked against the same complete numeric group. They are not checks for arbitrary filtered summaries or omitted observations.

Create VendorRanks, enter 3,2,7,5,9,7 in A1:A6, and put the following formulas in C:

The PlanMaker 2018 manual, pages 631–632 already documents RANK.AVG. Its third example asks for the rank of three, giving five; the current page instead asks for five, giving four. Both are consistent with the displayed dataset. The manual’s Excel 2010 note does not establish a PlanMaker introduction version.

A fractional rank is an expected average-position result. Rounding it to an integer can hide the tie convention. Display rounding in the input can also make unequal stored measurements appear tied; decide whether to rank original values or an explicitly transformed dataset.

The checked entry does not fully establish mixed text, logical cells, error propagation or all-empty cases. RANK and RANK.EQ use best positions for ties. AVERAGE averages measurements, while LARGE retrieves a value at a position.