Excel Function

FILTER

Filters rows using include condition.

FILTER(array, include, [if_empty])

Arguments

array

Required

Specify a reference range. You can drag or click start/end cells.

include

Required

Enter an expression such as comparison or calculation.

if_empty

Optional

Enter a text value (wrap with quotes when needed).

Practice Preview

show only rows that match a condition. Use FILTER to Filters rows using include condition. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. use C2:C8="食品" for include, use "該当なし" for if_empty. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=FILTER(A2:D8, C2:C8="食品", "該当なし")

Practice This Function

Practice in Sequential Mode Back to Function List