Microsoft Excel Filter Function

The FILTER function allows you to filter a range of data based on criteria you define.

=FILTER(ARRAY,INCLUDE,[IF_EMPTY])

ARRAY = THE RANGE OR ARRAY TO FILTER

INCLUDE = AN ARRAY OF BOOLEANS WHERE TRUE REPRESENTS A ROW OR COLUMN TO RETAIN

[IF_EMPTY] = RETURNED IF NO ITEMS ARE RETAINTED (OPTIONAL)

DOWNLOAD EXCERCISE FILES

COM-ExcelFilterFunction-01

.xlsx

Download XLSX • 15KB

ExcelFilterFunction-01

.xlsx

Download XLSX • 14KB