Results 1 to 3 of 3

Advance Filter not returning expected results

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    418

    Advance Filter not returning expected results

    Good evening all

    I'm looking for some assistance with an advanced filter please,,, been distracting me for a few hours now......

    I have 2 advanced filters which are nearly identical one for Sections/Departments,, this one is working perfectly.

    The one I'm having trouble with is to filter department training. This is only returning 1 line from the list criteria...

    I am using this code. The 'FilterSecDep' is working perfectly... the 'FilterTrg' has the issue

    Many thaks for the help

    Jim

    Sub FilterTrg()
    
    Sheet3.Range("AA1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
            CriteriaRange:=Sheet3.Range("AF1:AF2"), CopyToRange:=Sheet3.Range("AG1:AH1"), Unique:=False
    
    End Sub
    Sub FilterSecDep()
    
    Sheet3.Range("S1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
            CriteriaRange:=Sheet3.Range("V1:V2"), CopyToRange:=Sheet3.Range("W1"), Unique:=False
    
    End Sub
    Attached Files Attached Files
    Last edited by JamesT1; 05-20-2022 at 04:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] INdex and match not returning expected results
    By Ron Purpura in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-02-2021, 08:38 PM
  2. [SOLVED] Problem with index/match formula - not returning expected results
    By gsdanger in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-16-2018, 12:50 AM
  3. [SOLVED] Search Function Not Returning The Expected Results
    By adam_d_john in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-29-2017, 02:40 PM
  4. Formula not returning expected results
    By Mlabrec in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-07-2016, 08:08 PM
  5. CHOOSE Function not returning expected results.
    By khughes46 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-30-2014, 06:32 AM
  6. Replies: 4
    Last Post: 11-07-2012, 02:57 PM
  7. Lookup not returning expected results
    By syphlix in forum Excel General
    Replies: 4
    Last Post: 03-08-2011, 04:16 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1