+ Reply to Thread
Results 1 to 2 of 2

Dynamic filtering with multiple (5+) conditions

  1. #1
    Registered User
    Join Date
    07-03-2020
    Location
    North West
    MS-Off Ver
    2016
    Posts
    1

    Dynamic filtering with multiple (5+) conditions

    I have a large excel macro enabled document with multiple tabs. I am trying to sort a very large list (8 columns, 50,000 rows) by using condition 'must contain word' 'must not contain word' to reduce the size of the list at Column A. Column A contains whole sentences.

    I am constrained with this document as it is a Word document so I cannot install/download a Macro tool e.g. Kutools for instance. I can only work with Excel's VBA code, Excel's filter options or Excel's formula options.

    I cannot use Excel's Custom Autofilter as this only allows 2 conditions and I need at least 8 separate conditions.
    Is there a way of using Excel's Custom Autofilter for 8 separate conditions for example 'must contain word book', 'must contain hat', etc.? bearing in mind that these conditions have to draw out a single word from a sentence.

    Thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,750

    Re: Dynamic filtering with multiple (5+) conditions

    Hard to say without seeing some sample data, but consider using a helper column to test each row for your criteria (eg (and A1'"blah", B1 <>"blah", C1="This", D1<>"That")
    Then filter based on those results?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. dynamic filtering of data with multiple criterias
    By Agreth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-19-2017, 04:31 PM
  2. Replace multiple SumProduct/Vlookup with a dynamic array of conditions
    By Faboolous in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-18-2016, 11:55 AM
  3. [SOLVED] Replace multiple SumProduct/Vlookup with a dynamic array of conditions
    By Faboolous in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2016, 11:12 AM
  4. Creating dynamic top 10 list with multiple conditions and criterias
    By yabadabado in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2014, 10:11 AM
  5. [SOLVED] How to create a dynamic dropdown based on multiple lookup conditions
    By psilens in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-06-2014, 10:05 AM
  6. [SOLVED] Dynamic Count and Sum Array Formulas Based on Multiple Conditions
    By 5150 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-27-2014, 04:35 PM
  7. Replies: 2
    Last Post: 05-10-2009, 04:21 AM

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