MS Excel Advance Filtering
Not what you're looking for?
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!!
Purchase this Solution
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.
Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
C# variables and classes
This quiz contains questions about C# classes and variables.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.