6.2 Search for top N, last N
Here below is a sales statistical table:
Now we want to find out the products ranked in the top 10 by sales and their sales, and the last 10 products and their sales. The results are shown as below:
Top 10:
=spl("=E(?1).sort(ProductSales:-1).to(10)",A1:C78)
Last 10:
=spl("=E(?1).sort(ProductSales:-1).to(-10)",A1:C78)
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1653958231690
https://c.scudata.com/article/1654046145985
SPL Official Website 👉 https://www.esproc.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.esproc.com
Discord 👉 https://discord.gg/2bkGwqTj
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/
