Sheetsdrill

Level 4: Arrays and FILTER Exercise 70 of 92

Distinct values in order

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

List every department that appears in column B once, in alphabetical order, joined into one cell with a comma and a space. Answer in E1.

What this exercise teaches

UNIQUE keeps values in the order they first appear, so SORT goes around it, not inside it, when you want the distinct list sorted. JOIN is only needed because the answer has to fit one cell.

A hint if you get stuck

UNIQUE removes the repeats, SORT puts the result in order and JOIN turns the list into one cell. Each function wraps the one before.

Functions used: JOIN, SORT, UNIQUE

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