The FILTER function allows you to filter a range of data based on criteria you define. Note: This function is currently available only to Microsoft 365 subscribers. In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string (""). Syntax The FILTER function filters an array based on a Boolean (True/False) array. =FILTER(array,include,[if_empty]) Argument Description ...