6.5 Search for row number that satisfies the condition

 

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

imagepng

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.

imagepng


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