Skip to content
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.