Microsoft Excel — Hard
Key points
- FILTER creates a new array of matching data
- It operates on one or more Boolean conditions
- Unlike AutoFilter, FILTER doesn't hide rows
- The function automatically spills results to adjacent cells
- It's a dynamic array function
Ready to go further?
Related questions