ExcelHeroThe FILTER function
Returns the rows that meet a condition.
How to write it
=FILTER(array, include, [if_empty])- array
- What to return.
- include
- A test like B2:B7="Tech".
- if_empty
- Optional. What to show if nothing matches.
💡 Combine tests: (a)*(b) means AND, (a)+(b) means OR.
Try it
List everyone in the Tech team.
A
B
C
D
E
F
1
Name
Team
Salary
Years
Tech
2
Nora
Sales
52000
3
3
Omar
Support
41000
1
4
Priya
Sales
61000
6
5
Quinn
Tech
72000
4
6
Rosa
Support
39000
2
7
Sven
Tech
80000
8
Show the names where the Team is "Tech".