...
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)
