6.6 Search for row that satisfies the condition

 

We have a statistical table for daily sales of January 2022:

imagepng

The following code is to find out the data with daily sales greater than 1,000:

=spl("=E(?1).select(Sales>1000)",A1:B32)

imagepng