+ Reply to Thread
Results 1 to 1 of 1

Advanced filter nested IF/OR criteria

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Advanced filter nested IF/OR criteria


    I have an Advanced filter to sort list of employees by several criteria at once. Supervisor name / Position / Branch are all named ranges with unique values.

    I would like to have a data validation for Experience with following options:

    If I pick 4-7 the advanced filter should extract all staff who have 4 or 5 or 6 or 7 years next to their name in Experience column.

    My existing (and working) formula for Position is:

    E6 is the reference to cell where a list with data validation is, if you click it, you'll see dropdown with Clerk/Driver/IT etc. However if you won't select anything I'm using "*" which shows every employee on the list if you run the advanced filter.

    Any ideas would be more than welcome, thank you!

    Excuse me for not providing the link to other forum where I've posted this dreadful question

    If I manage to find solution I'll update both sites with the anwser for everyone.
    Thank you!
    Last edited by Samanar; 08-22-2017 at 01:47 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Advanced Filter Code : Criteria Range More Than 1 Row Breaks Filter
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2021, 04:30 PM
  2. Replies: 0
    Last Post: 08-04-2017, 02:39 AM
  3. Advanced filter for several criteria
    By TheBuginator in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-11-2014, 04:48 PM
  4. Advanced Filter : One Criteria Cell Breaks the Filter - Returns Only Headers
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 10:06 AM
  5. Advanced Filter, nested =IF function, or possibly some other tricker *please help*
    By mmarshall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2008, 09:49 PM
  6. Replies: 1
    Last Post: 06-26-2008, 08:42 PM
  7. Help req with advanced filter criteria
    By Jimbo in forum Excel General
    Replies: 5
    Last Post: 01-28-2005, 09:06 PM

Tags for this Thread


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