+ Reply to Thread
Results 1 to 2 of 2

AutoFilter Wildcard "Exact"

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    london
    MS-Off Ver
    excel 2003/2007/2010
    Posts
    15

    AutoFilter Wildcard "Exact"

    All,

    Having trouble with an autofilter, google is not helping.

    I am trying to auto filter a specific column by a wildcard. However, I want the filter result to be "exact" as opposed to "contains".

    This is what I have...

    Please Login or Register  to view this content.
    Have also tried:

    Please Login or Register  to view this content.
    to no avail...

    To reiterate, the autofilter works, however it filters the wildcard as "contains" as opposed to "equals"

    Any help would be appreciated as always!

    Chris

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,317

    Re: AutoFilter Wildcard "Exact"

    If you want it to be exact, then why the "*"

    Shouldn't it just be Criteria1:=FILTERIDNumber.Text
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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