6.7 Filter by multiple conditions

 

There is an employee information table:

imagepng

Now we want to find out the employees who are Female and were born before 1970:

=spl("=E(?1).select(Gender==""Female"" && Birthday<""1970-01-01"")",A1:O32)

imagepng