6.3 Filter by position

 

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

imagepng

Now we want to filter out the sales on even-numbered days:

=spl("=E(?1).select(#%2==0)",A1:B32)		

The symbol # represents the current row number.

imagepng


esProc Desktop and Excel Processing
6.2 Search for top N, last N
6.4 Search for position of a certain value, take the value by position