Rank records without sorting the source
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.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View 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.
No account. No upload. Just try it.