FormulaCraft

FILTER

FILTER returns the subset of a range where a condition is true, spilling the matching rows automatically and updating live as data changes. Available in Excel 365 and Google Sheets.

Excel
=FILTER(A2:B100, C2:C100="Open")
Google Sheets
=FILTER(A2:B100, C2:C100="Open")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2:B100 is the data to return.
  2. 2C2:C100="Open" keeps only rows where C equals Open.
  3. 3The matching rows spill down automatically.

Need a version for your data?

Try: “Show only the rows where status in column C is Open”

Related

VLOOKUPXLOOKUPINDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: