TheFILTER functioncan be used to extract data arranged vertically (in rows) or horizontally (in columns).

FILTER will return the matching data in the same orientation.

Semicolons (;) would indicate rows.

Excel formula: Basic filter example

FILTER returns this data in the original horizontal structure.

Because FILTER is adynamic array function, the resultsspillinto the range B10:D15.

If data indata(C4:L6) changes, the result from FILTER is automatically updated.

Excel formula: Filter this or that

The output from FILTER is dynamic.

If source data or criteria change, FILTER will return a new set of results.

FILTER function basic example

Excel formula: Filter text contains

Excel formula: Filter exclude blank values

Excel FILTER function

Excel TRANSPOSE function

Article image