+ Reply to Thread
Results 1 to 3 of 3

Advanced Filter Between Two Columns all OR conditions (4 conditions)

  1. #1
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Advanced Filter Between Two Columns all OR conditions (4 conditions)

    How can I use Excel Advanced Filter to do the following formula:

    =IF(OR(J21>1000,J21<-1000,K21>1000,K21<-1000),1,"")


    So I want it to filter if either column J or K has a value below -1000 or above 1000. I have tried the following but it doesn't work completely:

    Variance1 Variance2
    >1000 >1000
    <-1000 <-1000

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Advanced Filter Between Two Columns all OR conditions (4 conditions)

    Assuming row 21 is the top row of data in your table, use two cells for the criteria range. Leave the top one blank and enter the following formula into the bottom one
    =OR(J21>1000,J21<-1000,K21>1000,K21<-1000)
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Re: Advanced Filter Between Two Columns all OR conditions (4 conditions)

    Quote Originally Posted by xlnitwit View Post
    Assuming row 21 is the top row of data in your table, use two cells for the criteria range. Leave the top one blank and enter the following formula into the bottom one
    =OR(J21>1000,J21<-1000,K21>1000,K21<-1000)
    Perfect! Thank you!

+ 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. Replies: 7
    Last Post: 11-17-2016, 08:26 AM
  2. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  3. [SOLVED] conditions for advanced filter
    By ammartino44 in forum Excel General
    Replies: 3
    Last Post: 08-29-2015, 10:24 AM
  4. [SOLVED] Advanced Countif query - multiple conditions.
    By kevin.r in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2014, 11:13 AM
  5. 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
  6. Replies: 1
    Last Post: 08-10-2011, 06:40 AM
  7. Advanced unique cell count with multiple conditions ... help!
    By Flystar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-24-2005, 10:50 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