Share
Explore BrainMass

MS Excel Advance Filtering

I am having a problem with criteria range. I do not know how to set two different criterias in one column. I need to ADVANCE FILTER all of the Clerks (1 and 2) and the Sect. 1 workers who make more than $5.50/hr. I do not understand how to set the title criteria for more than one title. It HAS to be advanced filtered, not auto-filtered. I already have the database labeled and the criteria page ready to go, I just need to figure out how to set the title criteria for more than one title position.

Here is the database that goes with this problem:

A B C D E F G

3 Last Sex SS Number Title Class Yrs.Emp. Pay
4 Winston F 980-54-7654 Clerk 2 3 18 $5.25
5 Ricks F 546-90-8876 Sect. 1 3 9 $5.50
6 Miller M 101-99-1193 Sect. 1 3 7 $5.78
7 Larson F 676-45-3211 Clerk 1 3 9 $5.95
8 Thomas M 209-78-6543 Installer 3 11 $6.34
9 Flan F 300-74-4535 Clerk 1 3 16 $6.45
10 Evans F 908-57-4678 Clerk 2 3 14 $6.95
11 Murillo M 556-87-8839 Tech. Dev. 2 11 $7.25
12 Osborn M 786-45-6754 Repair 3 11 $7.74
13 Owens F 465-45-5678 Admin. 3 19 $6.55
14 Hines F 209-86-5646 Installer 3 14 $8.89
15 Sandy F 769-43-2121 Sales Rep. 3 15 $8.99
16 Altman M 565-56-5665 Sales 2 11 $9.02

Please help me figure out how to ADVANCE filter for the Clerks and Sect. 1 workers who make more than $5.50.

Thanks!!

Solution Summary

The expert uses employees and criteria to filter list based on years and pay rate. The two different criterias in one column is determined.

$2.19