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


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1653958347144
https://c.scudata.com/article/1654046219485