← Back to level 3
Level 3Next
FILTER + UNIQUE
A hard advanced array formula that filters a list and removes duplicates at the same time.
Syntax
=FILTER + UNIQUE(...)Step-by-step explanation
- 1Select the list or table that will be processed by the dynamic array formula.
- 2Add the filter or sorting rule so Excel knows which rows to return.
- 3Check the spilled output to make sure the visible results match the rule.
Common mistakes
Expecting it to keep duplicate rows
Blocking the spill area
Using it when a simple UNIQUE or FILTER is enough
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 96 |
Formula
=FILTER + UNIQUE(A1:B2)
Result
Advanced output
Worked example
- 1Look at the rows that meet the condition or contain repeated values.
- 2Apply =FILTER + UNIQUE(A1:B2) so Excel spills only the requested rows or unique items.
- 3The displayed output should resolve to Advanced output.
Practice area
Use FILTER + UNIQUE when repeated values should disappear from a live filtered result.
Match against the syntax block above.