Build a filtered priority queue with a stable tie rule
Your goal: Select one team at or above a points threshold, then sort the complete records by points descending and numeric ticket ascending.
Full 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.
Two matching tickets tie on pointsChoose records for the queue
- Team
- Ops (G2)
- Points
- At least 6 (G3)
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 | |||
| 8 | |||
| 9 |
Step 1 of 2
Choose records for the queue
How the Excel rule works
Include only the selected team’s tickets that meet the inclusive points minimum. Keep the whole record together.
Inspect selected records
No records selected yet.
Selected queue records