Results 1 to 8 of 8

advanced filter three conditions does not contain, between and contain

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-02-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    116

    advanced filter three conditions does not contain, between and contain

    Hi
    Can anyone help I have a database that I want to query with three conditions using advanced filter, see attached doc, Im not sure what to put in the filters for each to get the desired result
    QUERY
    Show venues that meet all three criteria
    Criteria 1
    SHOW VENUES THAT ARE NOT IN THE FOLLOWING CITIES: ARBROATH, DERBY, NEWPORT
    Criteria 2
    Only show venues with capacities in either of the three rooms that are between 100 and 200 but include blanks
    Criteria 3
    Only show venues that have type T or blank
    result should be
    Brunton Theatre

    Thanks in advance
    Dave
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] conditions for advanced filter
    By ammartino44 in forum Excel General
    Replies: 3
    Last Post: 08-29-2015, 10:24 AM
  2. 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
  3. Replies: 5
    Last Post: 12-19-2013, 06:58 AM
  4. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  5. Delete Rows hidden by either Auto Filter and Advanced Filter
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:29 AM
  6. Advanced filter with some conditions & copy filtered value to next sheet
    By sudhirkumar3429 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2012, 05:46 AM
  7. [SOLVED] advanced filter a range:Advanced Filter function
    By Il Principe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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