How to use the FILTER() dynamic array function in Excel Your email has been sent Filtering ... FILTER() returns only one record, so let’s remove James from I4 and return a descending sorted ...