+ Reply to Thread
Results 1 to 5 of 5

Excel 2013 Advanced Filtering using Multiple Criterias

Hybrid View

  1. 03-02-2017, 06:56 PM #1
    TallTex
    TallTex is offline
    Registered User
    Join Date
    03-02-2017
    Location
    Austin, TX
    MS-Off Ver
    2013
    Posts
    5

    Excel 2013 Advanced Filtering using Multiple Criterias

    Hi all. In the attached file, I am trying to run an advanced filter whereby the following conditions are met:

    #OUTP-ADDR
    -if a record is a PO Box, STE, or APT - exclude those records

    or

    #OUTP-STATE
    -if the state is not "TX" - exclude those records

    or

    Send
    -if its not "Y" - exclude those records

    i believe i have entered everything correctly, but the filter doesn't work. I've tested each criteria independently, and they each work, but collectively, they don't. if anyone can help, it would be much appreciated! Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-02-2017, 10:05 PM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,902

    Re: Excel 2013 Advanced Filtering using Multiple Criterias

    Hello and Welcome to Excel Forum TallTex
    If I understand you want all of the conditions to be true, so it is not STE and not PO Box and not APT and TX and Y
    That being the case they all need to be on the same line (they all carry the same weight) so the criteria range will be A1:K2 (as seen in the attached file).
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  3. 03-03-2017, 03:43 PM #3
    TallTex
    TallTex is offline
    Registered User
    Join Date
    03-02-2017
    Location
    Austin, TX
    MS-Off Ver
    2013
    Posts
    5

    Re: Excel 2013 Advanced Filtering using Multiple Criterias

    JeteMc - you are correct. Thanks!
    Reply With QuoteRegister To Reply
  4. 03-03-2017, 03:45 PM #4
    TallTex
    TallTex is offline
    Registered User
    Join Date
    03-02-2017
    Location
    Austin, TX
    MS-Off Ver
    2013
    Posts
    5

    Re: Excel 2013 Advanced Filtering using Multiple Criterias

    how do i mark the thread as solved?
    Reply With QuoteRegister To Reply
  5. 03-03-2017, 05:28 PM #5
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,902

    Re: Excel 2013 Advanced Filtering using Multiple Criterias

    You're Welcome and thank you for the feedback. To mark the thread as 'Solved' use the thread tools link above your first post. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Preparing for MOS 2013 Excel Foundation, Intermediate and Advanced Certification
    By Anantha Bhaskar in forum Excel General
    Replies: 2
    Last Post: 07-14-2016, 08:41 AM
  2. Advanced Filter with Multiple Criterias
    By etaver87 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-13-2016, 12:24 PM
  3. Excel 2013 - Filtering/DrilDown Data
    By dducky in forum Excel General
    Replies: 2
    Last Post: 12-16-2014, 10:25 AM
  4. [SOLVED] Search multiple attributes across several columns, VBA Advanced Filtering
    By dannyjoer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2013, 06:48 AM
  5. Excel advanced filtering on multiple sheets
    By blind527 in forum Excel General
    Replies: 4
    Last Post: 05-04-2013, 08:56 PM
  6. Advanced filtering with multiple lines in VBA code
    By surfthenet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2012, 06:56 AM
  7. Advanced Filtering with multiple criteria
    By drumbody in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2007, 08:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1