INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works ...

There’s the top five records. The function creates a new table named Top 5 Sales and populates it with the data in the Sales table, but copies only the first five records in the sorted dataset.

Figure A shows a simple data set in a Table object and a list of unique names—the result of a UNIQUE () function that uses only one argument, the array argument: H3: =SORT (UNIQUE (D3:D13)) Figure A ...