Here below is a sales statistical table:

Now we want to find out the product ranked tenth by sales and its sales, and the product ranked tenth from last by sales and its sales. The results are as follows:
The 10th:

=spl("=E(?1).sort(ProductSales:-1)(10)",A1:C78)

The 10th from last:

=spl("=E(?1).sort(ProductSales:-1).m(-10)",A1:C78)

esProc Desktop and Excel Processing
5.11 Split multi-Sheet file into multiple files - unfixed number of Sheets
6.2 Search for top N, last N