Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Johannesburg, Gauteng, South Africa
    Posts
    59
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi all, I hope you can help mw (as usual) with my problem:

    The Data I wish to filter in the attached workbook sits in A6:AD1180. The Criteria sits in B1:B3. It does not filter. If I change the Criteria to B1:B2 it works. What am I doing wrong?

    Thanks in advance

    Raymond

    [attachment=85647:AdvancedFilter.xls]

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Criteria on two different rows act as "or": rows must satisfy one condition or the other (or both). But in your situation, ALL rows satisfy "<>DELETION CASES or <>TEMP".

    I think you want "<>DELETION CASES and <>TEMP". For that, the conditions must be on the same row, so you must repeat the CurrentClass column header, and place <>DELETION CASES under one of them and <>TEMP under the other.

  3. #3
    Star Lounger
    Join Date
    Jun 2002
    Location
    Johannesburg, Gauteng, South Africa
    Posts
    59
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks Hans, I'm a bit slow today!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •