Chapter 8 Functions that spill ・ MISSION 31

Mission 31: List the salespeople

📋 Mission list

Task

Enter one formula in E2 to list the salespeople (without duplicates) from E2 down.

Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.

Chapter 8 startsFunctions that spill

Chapter 8 ・ MISSION 31

List the salespeople

Enter one formula in E2 to list the salespeople (without duplicates) from E2 down.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =UNIQUE(A2:A9)

UNIQUE returns a list without duplicates and spills down as far as needed. If a cell in the way has a value, you get #SPILL!.

To practice one function at a time:Function drillExcel function list

* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).