If you have all these in separate columns then select the range with header
row and choose Data|Auto Filter then go into each columns and choose what you
want...

or enter criteria in a range (with header in row 1 and conditon in row 2
below, select that range and choose Data|Advance Filter


--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"erik" wrote:

in three rows, i have to use advanced filtering to display all part-time
employees working within a certain city as well as full-time employees
working at home and earning 40,000 or more.