Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 1/4

UNIQUE: each value once

Exercise 1 of 3

In E2, list each region once.

About this lesson

UNIQUE lists each value once. The result spills into the cells below on its own.

In this lesson

  1. In E2, list each region once.
  2. In E2, list each product once.
  3. In E2, count how many different regions there are, in one formula.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in E2 and press Enter to check.