6.6 Search for row that satisfies the condition
We have a statistical table for daily sales of January 2022:
The following code is to find out the data with daily sales greater than 1,000:
=spl("=E(?1).select(Sales>1000)",A1:B32)
esProc Desktop and Excel Processing
6.5 Search for row number that satisfies the condition
6.7 Filter by multiple conditions
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.scudata.com
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/