Computer Science Homework Solutions
Problem
#180653

Advanced Filtering range criteria

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

Uses employees and criteria to filter list based on years and pay rate

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
  • Plain text response
  • Attached file(s):
    • 180653 Advanced Filter.xls
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
Browse