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
Comments