...
6.1 Search for the nth, the nth from last
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)
