You're an HR analyst extracting just the Active employees from a 12-row roster. Columns A–C contain EmployeeID, Name, and Status (Active/Inactive). The ActiveName header sits in E1.
Your task:
- In E2, write a single FILTER formula that returns the Names of Active employees, in their original order. The result spills down — don't drag.
There are 6 Active employees in the data; FILTER will spill them into E2:E7.
The classic non-array alternative is a complex INDEX/SMALL/IF/ROW formula or a helper column with running counts — both verbose and brittle. FILTER is the modernization that collapses all of that into one expression.
Graded cells: E2 (=Alice Brown), E5 (=Frank Gomez), E7 (=Jack Kim).
Open this problem on a desktop to attempt it.