how do i use advanced filtering?

  • Thread starter Thread starter erik
  • Start date Start date
E

erik

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.
 
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
 
Hi,

Since you are using Advanced Filter for this the criteria range will look
like:

Status City Worksite Salary
Part Time New York
Full Time Home >=40000

If the city for the Full Time employees is also New York you must add it.
I'm sure you know that the titles must match the titles in the data table.

You can not do this with Auto Filter.


If this helps, please click the Yes button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs across multiple columns using OR 2
How do I clear an Advanced Filter 1
multiply criteria in a range using sumifs 1
reference cell from advanced filter 3
Daily Time Sheets with Rounding 1
Advanced Filter how to include columns 1
How do I use the LOOKUP feature in Excel 2
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top