Explore BrainMass
Share

Explore BrainMass

    MS Excel Advance Filtering

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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!!

    © BrainMass Inc. brainmass.com October 9, 2019, 9:19 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/ms-excel-advance-filtering-criteria-180653

    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