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



178 views0 comments