How to Rank Tied Scores with RANK.EQ in Excel

Open an Excel workbook (.xlsx) in Cue Office and use RANK.EQ to add a rank column next to your scores. Set the third argument to 0 to rank from highest to lowest. Tied scores share a rank. If two readers tie for second, the next reader ranks fourth.

Rank five readers with RANK.EQ

The reading program has five scores in B2:B6. Enter the formula in C2 and check that Maya’s score of 82 ranks fourth.

Reading points table with five readers and an empty Rank column
The original table lists five readers in their entry order, leaving the Rank column for formulas.
=RANK.EQ(B2,$B$2:$B$6,0)
Entering RANK.EQ in C2 displays Maya's rank as 4
C2 compares the score of 82 in B2 against all five scores.

B2 is the score for the current row and changes as you fill down. $B$2:$B$6 locks the comparison range for all five readers. The final 0 ranks scores in descending order.

Select C2:C6, then click Home → Fill → Fill Down. Select C6 to check that the formula now uses B6 and still compares against $B$2:$B$6.

The first item in the Fill dropdown menu is Fill Down
With C2:C6 selected, choose Fill Down from the Fill menu.

Read down the original rows and you’ll see 4, 1, 2, 2, 5. Luis ranks first with 96 points. Priya and Noah tie for second with 90 each. Three readers scored higher than Maya, so her 82 points put her fourth.

Five reader ranks are 4, 1, 2, 2, 5, with the formula bar showing C6's locked comparison range
Two scores of 90 tie for 2nd, so the next rank is 4th.

Change a score, then reopen to check the ranks

Use File → Save As… to keep a copy with the original scores. In a test copy, change Noah’s score in B5 from 90 to 98. The ranks now read 4, 2, 3, 1, 5 in the original row order. Save the test copy, close it, and reopen it. Noah should rank first and Luis second, with the reader names still in their original order.

After changing scores and reopening the manual copy, Noah is 1st with 98 points and Luis is 2nd with 96 points
After changing B5 to 98 and reopening the saved file, Noah's rank is 1.

Ask Cue AI to fill the Rank column

Open the unranked original table and instruct Cue AI to populate only C2:C6 using a formula that recalculates when scores change, specifying how to handle tied scores.

Could you rank the reading scores in the Rank column, C2 through C6? Give the highest score rank 1, give tied scores the same rank, and skip the next rank after a tie. Keep the reader order and points as they are. Use formulas so the ranks update when a score changes.
Opening of the Cue AI test prompt, requesting ranks in the Rank column from C2 to C6
Ask Cue AI to add ranks only in the Rank column.

In this run, Cue AI wrote =RANK(B2, $B$2:$B$6) in C2 and used the same comparison range in the other four formulas. The older RANK function ranks from highest to lowest when you omit its third argument. After saving and reopening, the original scores still rank 4, 1, 2, 2, 5.

After reopening the AI-generated file, the formula bar shows RANK, and the five ranks remain 4, 1, 2, 2, 5
After reopening the AI copy, there are still two 2nd-place ties, followed by 4th place.

After reopening, temporarily change B5 to 97. The ranks immediately update to 4, 2, 3, 1, 5. The saved AI workbook still has Noah’s original score of 90.

After reopening the AI copy, temporarily changing Noah to 97 points causes the ranks to recalculate automatically
Temporarily changing B5 to 97 after reopening immediately moves Noah to 1st.

Practice with the five reading scores

Expand full example

Paste the tab-separated data below starting in A1. Leave the Rank column blank, add the formula, and then try editing the score in B5.

Reader	Points	Rank
Maya	82
Luis	96
Priya	90
Noah	90
Amina	75
Five reader ranks are 4, 1, 2, 2, 5, with the formula bar showing C6's locked comparison range
Two scores of 90 tie for 2nd, so the next rank is 4th.

Use the updated ranks in the reading program announcement

If you enter more points after the first count, ask Cue AI to draft an announcement from the updated Points and Rank columns. Check the winner and any ties against the worksheet before sharing it. In the original scores, Priya and Noah tie for second, so include both names.

Keep the scores and rank formulas in Excel (.xlsx), and write the announcement for parents or readers in Word (.docx). At the closing event, use one PowerPoint slide (.pptx) to show scores and tie results. Cue Office opens and edits all three file formats for free. Before sending a PDF announcement, you can use the free PDF viewer to check the tied readers' names and rankings. Download Cue Office for free