Announcement

Collapse
No announcement yet.

Advance Filter with multiple criteria

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Advance Filter with multiple criteria



    I learned a lot working with royUK on advance filter. The question i have is Advance FIlter can only have 2 criteria. In a project I'm working I really need many more or can i use a "Wildcard" for example in my code written I have 1820 and if i can change to 18** I can filter more groups instead of individual. Learning and love the speed of ADV FIlter


    Code:
    .AutoFilter Field:=1, _
                            Criteria1:="1820", _
                            Operator:=xlOr, _
                            Criteria2:="1440"

  • #2
    I found he wild card as ???. Sorry didnt work first time but think i had a typo

    Comment


    • #3
      excellent thanks for posting the solution
      If the solution helped please donate to RSPCA

      Sites worth visiting: Rabbitohs | Excel-it royUK | Excel Matters Rory | Kris' Spreadsheet Solutions | Domenic xl-central | The Smallman

      Comment


      • #4


        That code is for AutoFilter not AdvancedFilter
        Hope that Helps

        Roy

        New users should read the Forum Rules before posting

        For free Excel tools & articles visit my web site

        RoyUK's Web Site

        royUK's Database Form

        Where to paste code from the Forum

        About me.

        Comment

        Working...
        X