A sorted list from QUERY
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Use QUERY on A2:B9 to pick the names of the reps with sales above 10,000, highest sales first, and JOIN them into one cell with a comma and a space. Answer in E1.
What this exercise teaches
where filters, order by sorts and select picks the column, all in one step. QUERY returns a list, and JOIN packs that list into a single cell.
A hint if you get stuck
The query is "select A where B > 10000 order by B desc". The range starts at row 2, so the third argument, the number of header rows, is 0.
Try it now, free, no account needed
Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Arrays and FILTER
- Sum a filtered list
- Two conditions in FILTER
- Distinct customers
- Best seller with SORT
- Top three deals with SORTN
- Revenue with ARRAYFORMULA
- Codes that are too long
- QUERY for a total
- Top region with QUERY
- Count with QUERY
- Either region with FILTER
- Distinct products in a region
- Revenue above a minimum quantity
- Average since a date with QUERY
- QUERY with a cell in the where clause
- QUERY with contains
- Total overspend with ARRAYFORMULA
- Distinct values in order