PracticeExcelSign in
Excel practice exercises

SORT and UNIQUE practice exercises

Sort a table by any column and pull out a list without duplicates, with formulas that update the moment the data changes.

Start the first exercise
  1. 1Sort a table by sales with SORTIn D2, return the table A2:B6 sorted by sales, highest first. SORT takes the range, the column to sort by (2) and the order (-1 for descending).
  2. 2List each customer once with UNIQUEPremiumIn D2, list every customer in B2:B8 once, without the repeats, with UNIQUE.
  3. 3A sorted list without duplicatesPremiumIn D2, list every rep in B2:B9 once, sorted from A to Z. Put UNIQUE inside SORT.

Functions in this topic