+ Reply to Thread
Results 1 to 1 of 1

Advanced filter nested IF/OR criteria

  1. #1
    Registered User
    Join Date
    02-27-2017
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Advanced filter nested IF/OR criteria

    Hello,

    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:
    0-1
    2-3
    4-7
    7+

    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:
    =If(E6="","*",E6)

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

    EDIT:
    Excuse me for not providing the link to other forum where I've posted this dreadful question
    http://www.ozgrid.com/forum/showthread.php?t=205303

    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. [SOLVED] 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

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