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.
ExcelPro has 880+ hands-on exercises across 9 tracks — type real formulas, get instant feedback.
Start practising free →