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.
=RANK.EQ(B2,$B$2:$B$6,0)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.
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.
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.
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.
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, 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.
Practice with the five reading scores
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