Chapter 8 Functions that spill ・ MISSION 32
Mission 32: Extract one person's sales
Task
Enter one formula in E3 to extract only the rows where the rep is F1 (Emma).
E3fx
A
B
C
D
E
F
G
1
Rep
Product
Sales
Rep
Emma
2
Liam
A
120000
3
Emma
B
80000
4
Liam
C
45000
5
Olivia
A
150000
6
Emma
A
60000
7
Olivia
C
30000
8
Liam
B
90000
9
Emma
C
70000
10
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 ・ MISSION 32
Extract one person's sales
Enter one formula in E3 to extract only the rows where the rep is F1 (Emma).
A
B
C
D
E
F
G
1
Rep
Product
Sales
Rep
Emma
2
Liam
A
120000
3
Emma
B
80000
4
Liam
C
45000
5
Olivia
A
150000
6
Emma
A
60000
7
Olivia
C
30000
8
Liam
B
90000
9
Emma
C
70000
10
A
B
C
D
E
F
G
1
Rep
Product
Sales
Rep
Emma
2
Liam
A
120000
3
Emma
B
80000
Emma
B
80000
4
Liam
C
45000
Emma
A
60000
5
Olivia
A
150000
Emma
C
70000
6
Emma
A
60000
7
Olivia
C
30000
8
Liam
B
90000
9
Emma
C
70000
10
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: =FILTER(A2:C9,A2:A9=F1)
Write the FILTER condition as a “column=value” comparison. Only the matching rows spill down and to the right, whole rows at a time.
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).