6.5 Search for row number that satisfies the condition
We have a statistical table for daily sales of January 2022:
The following code is to find out the date with daily sales greater than 1,000:
=spl("=E(?1).pselect@a(Sales>1000)",A1:B32)
pselect@a()means returning the sequence number of all rows that meet the condition, and pselect() means returning only the sequence number of the first row that meets the condition.
esProc Desktop and Excel Processing
6.4 Search for position of a certain value, take the value by position
6.6 Search for row that satisfies the condition
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/