How to use the FILTER() dynamic array function in Excel ... A numeric offset value that identifies the row or column to sort by sort_order: The number 1 for ascending sort or -1 for descending ...