AutoFilter for quick manual filtering. FILTER function for dynamic results that update automatically.
Dropdown arrows appear on every column header.
Uncheck values to hide them, or use Number Filters / Text Filters for conditions like "greater than" or "contains".
AutoFilter hides rows visually — the data is still there, just hidden. Clear the filter to show everything again.
When you copy filtered data, Excel includes the hidden rows by default. Press Alt+; to select only the visible cells before copying.
Returns a filtered copy of a range as a formula output. Original data stays untouched, and the output updates automatically when data changes.
=FILTER(A2:C100, B2:B100="North", "No results")
-- Returns all rows where column B = "North"
=FILTER(A2:C100, (B2:B100="North") * (C2:C100>1000), "No results")
-- AND condition: North AND amount > 1000
=FILTER(A2:C100, (B2:B100="North") + (B2:B100="South"), "No results")
-- OR condition: North OR South=SORT(FILTER(A2:C100, B2:B100="North"), 3, -1) filters to North region and sorts by column 3 descending — all in one formula.
Practice these formulas in the Data Analyst track — 100 exercises covering dynamic arrays, data cleaning, and analysis. Free to start.
Start the Data Analyst track free →