How to Use SORT in Excel to Rank Rows by Score
Open your Excel exhibitor score sheet (.xlsx) in Cue Office and use SORT to rank whole rows by score. The booth selection order appears beside the source table and updates when a score changes. The source rows stay in their original order.
How do you sort by score while keeping IDs and exhibitors together?
Create a new workbook in Cue Office and paste the practice data into A1. A2:C5 contains the IDs, exhibitor names, and scores. Check that column C contains numbers. Leave F2:H5 empty below the ranking headers in F1:H1.
Click F2 and paste the formula below. A2:C5 covers the ID, exhibitor, and score for each record. 3 sorts by the third column of that range, which is the score column. -1 sorts in descending order, spilling the four-row, three-column result starting at F2.
=SORT(A2:C5,3,-1)
How do you switch sort order and verify the ranking after reopening?
Click F2 and change the third argument from -1 to 1, or paste the ascending formula below. The right side sorts in order of 76, 84, 88, and 92, while the left side retains the original order of B14, B27, B09, and B33.
=SORT(A2:C5,3,1)
Restore the descending formula in F2 and choose Save As to create a new .xlsx file. Close and reopen the new file, then check that F2:H5 shows all four rows with scores of 92, 88, 84, and 76.
In one test, using Save after correcting the score data type in an older copy left only the ID in F2 visible on reopening. If you see that result, go back to the source sheet with numeric scores, enter the descending formula in F2, and use Save As. Reopen that copy to check all four rows.
How do you rank with Cue AI and confirm updates after changing scores?
Open a copy of the scoring sheet where F2:H5 is still blank and click Cue AI. Tell it to rank full records from highest to lowest by numeric score and specify where the output should begin.
Build a live booth-selection ranking below the existing headers, starting in F2. Use every full row in A2:C5, keeping each ID, exhibitor and score together. Rank from highest score to lowest using the numeric scores in C2:C5. The ranking should update when a source score changes. Edit only F2 and keep the source rows, their order and both sets of headers unchanged.
Cue AI writes the descending SORT formula only in F2. Save and reopen this copy, then check the source table on the left and F2:H5 on the right to confirm all four complete rows remain sorted in descending order.
In the reopened copy, change Clover’s score in C4 from 76 to 90. Clover stays on the same row in the source table, and the entire B09 row moves to second place in the ranking. The scores on the right now read 92, 90, 88, and 84.
Practice with four exhibitor records
Show the full example
Paste the entire data block into A1. The headers on the right are ready, leaving F2:H5 blank. Back to formula steps.
ID Exhibitor Score ID Exhibitor Score B14 Aster 84 B27 Bramble 92 B09 Clover 76 B33 Dune 88
Review score changes before publishing the selection order
After the next review round, provide Cue AI with the exhibitor table range, score column, and ranking start cell, then ask it to add rankings to the new scoring sheet. Before handing it off to on-site colleagues, pick a record with an updated score and check the exhibitor ID and name to make sure the entire row moved to the expected position. Then reopen the handover file to verify the scores and IDs for the top two spots.
Open the review panel’s score confirmation (.pdf) for free in Cue Office and compare the scores with your Excel scoring sheet (.xlsx) by exhibitor ID. Record any disputed scores and what the review found in a Word handoff log (.docx). To brief on-site staff, list the order for calling exhibitors to choose their booths in a PowerPoint deck (.pptx). Cue Office offers free spreadsheet, document, and presentation editing.