The data in B5:E16 is defined as anExcel Tablewith the namedata.

At this point, we have the data we want, but it is not sorted.

The output from FILTER is dynamic.

Excel formula: Basic filter example

If source data or criteria change, FILTER will return a new set of results.

from a set of numeric data.

Values can be sorted by one or more columns.

Excel formula: Filter this or that

SORT returns a dynamic array of results.

FILTER function basic example

How to show top or bottom n results

Excel formula: FILTER on top n values

Excel formula: Name of nth largest value

Excel FILTER function

Excel LARGE function

Excel SMALL function

Excel SORT function

Article image

Article image