To do that, select the Data tab, highlight the table, and click From Table/Range in the Get & Transform Data command group of ...

FILTER works well with other Excel functions like SORT and UNIQUE to create powerful data management combinations. You can nest FILTER inside SUM or AVERAGE formulas to calculate values from filtered ...