Sheetsdrill

Level 4: Arrays and FILTER Exercise 68 of 92

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.

Functions used: JOIN, QUERY

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 exercise

More exercises in Arrays and FILTER