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)

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1653878658632
https://c.scudata.com/article/1653958347144