There is an employee information table:

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)

esProc Desktop and Excel Processing
6.6 Search for row that satisfies the condition
6.8 Search by adjacent rows