Skip to main content
SheetTutor.
SheetTutorLearn Excel by playBack to task

Rank records without sorting the source

Your goal: Compare both rank directions and averaged ties beside the untouched source, then select configurable kth extrema.

Full task requirements

Keep A2:B7 in their original positions. Fill C2:C7 with descending competition ranks and D2:D7 with ascending competition ranks; ties share the first occupied position and leave gaps. E2:E7 and F2:F7 instead average the occupied tied positions in descending and ascending order. All six finite numeric scores participate, including zeroes and negative values; this exercise does not treat numeric text, Booleans or blanks as scores. I4 and I5 return maximum/minimum; I6 and I7 return kth largest/smallest using the integer H2 from 1 through 6, with duplicates occupying separate positions. Copy within each declared rank column only. Each summary formula has a separate job and must not be filled over. Source identifiers remain nonempty ASCII text and scores stay within ±1,000,000.

Ties, zero and a negative scoreRetain every original record and score0 cells selected
A/B remains in original record order, including ties, zeroes and negatives. H2 is the kth-order control.
Click or drag source cells; selected cells change color Drag from selected cells to deselect.
#
1
2
3
4
5
6
7
Step 1 of 4

Retain every original record and score

Select the source cells in the worksheet, then enter your prediction below.

Rules for this step

Select all record identities and numeric scores. Keep original worksheet positions; numeric zero and negative scores participate.

0 cells selected