Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 10

FILTER and UNIQUE in Excel

One formula, many results: filter a list, remove duplicates and turn rows into columns.

  1. Remove duplicates: UNIQUE. UNIQUE removes the duplicates from a list. The answer spills into the cells below by itself. List every region once, starting in C2
  2. Keep matching rows: FILTER. FILTER returns every row that meets a condition. The answer spills into the cells below by itself. List everyone who works in Sales, starting in D2
  3. What's a spill?.
  4. Your turn: TRANSPOSE. TRANSPOSE flips a range: a column becomes a row. The answer spills into the cells next to it. Turn the column of quarters into a row, starting in C2

← All lessons