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