Build a filtered priority queue with a stable tie rule
Enter one formula in G5 to return matching A2:D9 records for team G2 and points at least G3. Sort by points descending, then numeric ticket ascending. With no matches, return No matches in G5 and leave the rest of G5:J12 blank.
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
Enter one formula in G5 to return matching A2:D9 records for team G2 and points at least G3. Sort by points descending, then numeric ticket ascending. With no matches, return No matches in G5 and leave the rest of G5:J12 blank.
No account. No upload. Just try it.