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.

Columns A through C show four exhibitor records, while columns F through H contain only ranking headers
The original exhibitor table remains on the left, leaving space on the right for an independent ranking table.

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)
Formula in F2 is SORT(A2:C5,3,-1), with scores on the right ordered 92, 88, 84, 76
Descending order places Bramble's score of 92 first, keeping the ID and exhibitor name aligned with each score.

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)
Formula in F2 has 1 as the third argument, with scores on the right ordered 76, 84, 88, 92
Switching to ascending order places Clover's score of 76 at the top, leaving the left side unchanged.

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.

After saving as a new file and reopening, the numeric workbook shows four complete descending rows with the F2 formula intact
All four descending rows remain complete after reopening the saved-as workbook.

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.

Cue AI toolbar and panel alongside the blank ranking area on the right
The empty ranking area is to the right of the Cue AI pane. The results start at F2.
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.

Reopened AI workbook keeps the source table intact and shows the F2 descending formula with four results
After reopening, the ranking remains 92, 88, 84, and 76. The source records on the left stay in their original 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.

Clover in C4 updated to numeric 90, moving the entire B09 Clover 90 row into second place
Updating Clover from 76 to 90 moves the entire row from last place up to second place on the right.

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.

Download Cue Office for free