Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Is there any7 way to include more than 2 conditions in a custom autofilter?
    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Not directly. but you could add one or more columns to the table with formulas to calculate conditions, and filter on TRUE or FALSE. For example, you could have a formula =AND(A2=3,B2="Jeff",C2<0,D2<10%) in row 2 and filled down as far as needed. If you filter this column on TRUE, you'd get all rows for which all four conditions are satisfied

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •