Define problem with criteria range

Assignment Help Computer Engineering

Reference no: EM1335834

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.

Reference no: EM1335834

Questions Cloud

Computing variance at completion for project : A project had a budget of $750,000 and was completed on time. The project expenses, however, were 15 percent more than what the project called for. What is the variance at completion for this project?

What value does a performance management program : Explain What value does a performance management program bring to the organization and Which performance management programs did you consider

Measuring verbal and computational skills : Measuring verbal and computational skills to a group of applicants for a specific job.

Direct and indirect costs : Fee Setting - As the executive director of Advocates for Children, you have had a change of heart - perform all the computations necessary to set a fee. What will your fee be?

Define problem with criteria range : 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 create more than $5.50/hr. I do not understand how to set the title crite..

Illustrate what does the term recession mean : Illustrate what does the term "Recession" mean and how do we know when one occurs. How does government intervene to move the economy out of a recession.

Prepare an article abstract : Prepare an abstract that is a comprehensive summary of the content of an article and It should be non-evaluative. That is, not to critique the article.

Explain qualitative vs quantitative marketing research : Explain Qualitative vs Quantitative Marketing Research and Many marketing researchers have their favorite research approaches

Assume that initially the goods and services market : Assume that initially the goods and services market is in equilibrium at the potential

User Account

All Pages