Two reps closed the same number. Who ranks first?
Quarter-end arguments deserve better than eyeballing a sorted column. Rank and Percentile ranks every value, handles ties the way the classic Analysis ToolPak does, and shows what share of the field sits below each name.
Work Starter Statistics free
After you install, this is the model to open.
Rank the Leaderboard, Ties and All
- In your spreadsheet, click the Sortia icon in the strip of icons down the right-hand edge. No strip? Click the arrow at the bottom-right to open it. You can also use Extensions, then Sortia, then Open Sortia.
- Click Start from a template and put that name in the search box.
- Pick the card with that name and click Load this template. It arrives on a new tab with real numbers already in it.
The answer
The output sorts by value and settles the argument in two columns:
- Rank 1 (tied)
- 2 reps
- Next rank after the tie
- 3
- Tied leaders sit at
- 88.9% percentile
- Median rep
- $101K
When two people share first place there is no second: Priya and Dana both take rank 1 and Omar lands at rank 3, exactly the convention every classic stats tool uses, so your numbers match whatever HR exports. Works on anything you compete on: sales, race times, store revenue, exam scores.
The model
Ten reps and their Q2 sales. The tool ranks the numeric column; the Point column traces every rank back to its original row, so names survive the sort.
| Reps | 10, $79K to $118K |
| Tie at the top | Priya and Dana, $118K each |
| Rank per rep | calculated |
| Percentile per rep | calculated |
Once it is in your sheet
- The model arrives with real numbers in it and runs as it stands, so you can press the button first and understand it second.
- Change the numbers to yours. The sheet marks which cells are inputs and which hold formulas, and most labels carry a note explaining the row.
- Press the run button at the bottom of the panel. It is labeled for the tool you are in, and the result lands on its own tab, with a written reading of it beside the figures.
Never used Google Sheets? Start here goes the whole way, in seven steps, and assumes nothing.
Next question
- Is there a typo dragging your average up?Catch the Outlier Entry
- One group is wild, one is steady. Is the gap real?Manual vs Automated, Tested Fairly
- When the level shifts, how fast does your forecast follow?A Forecast That Trusts Recent Weeks
- What happens to the plan when reps leave?Will the Sales Team Make the Number?
- What is a pilot actually worth before you commit?Pilot First, or Go Big?
- What does each of the three budgets actually produce?Which of Three Budgets Should the Practice Plan On?
Every model like this one, and the method behind them: Statistics in Google Sheets.