6.1 Search for the nth, the nth from last

 

Here below is a sales statistical table:

imagepng

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)

imagepng

The 10th from last:

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

imagepng