+ Reply to Thread
Results 1 to 3 of 3

Autofiler Based on a List of Values in a Range (Include not Exact Match)

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Decin
    MS-Off Ver
    Excel 2010
    Posts
    28

    Autofiler Based on a List of Values in a Range (Include not Exact Match)

    Hi guys,
    I need an autofilter which filters rows based on a list of values (+50).

    The problem is that I am looking for rows INCLUDING values from the list, not for exact match.

    I am not able to make excel filter values including the values from the list... I am able just to filter values matching exactly values from the list.

    -----------
    Please Login or Register  to view this content.
    ----------

    Any ideas?
    Last edited by alansidman; 02-13-2014 at 01:02 PM. Reason: code tags added.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Autofiler Based on a List of Values in a Range (Include not Exact Match)

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between
    Please Login or Register  to view this content.
    tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (Because you are new to the forum, I have added them for you today. Please read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Autofiler Based on a List of Values in a Range (Include not Exact Match)

    You have to use the Advanced Filter and not the Auto Filter to use wildcards.

    Here is a tutorial on Advanced Filter and VBA from Chandoo.

    http://chandoo.org/wp/2012/11/27/ext...ubset-of-data/

    and an advanced filter explanation from Debra Dagleish

    http://www.contextures.com/xladvfilter01.html

+ 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. Compare list for Exact Match
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2013, 01:59 PM
  2. [SOLVED] How to match the exact value from the date range?
    By PRADEEPB270 in forum Excel General
    Replies: 2
    Last Post: 12-13-2011, 11:52 AM
  3. Searching Range for Exact Match
    By SATEAT in forum Excel General
    Replies: 4
    Last Post: 05-20-2010, 07:14 PM
  4. Range? Average.. Match.. Exact?
    By nastech in forum Excel General
    Replies: 1
    Last Post: 03-13-2006, 04:25 AM
  5. Replies: 0
    Last Post: 08-25-2005, 02:37 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1