Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello.
    I've created a procedure to place the active cell text into a criteria range and then use Advanced Filter with this criteria. The text is correctly placed in the cell, but the Advanced Filter process treats the criteria as though it were >=ALPHA rather than just ALPHA. How can I force it to just find precise matches to ALPHA?
    Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Can you attach a sample workbook?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='777653' date='31-May-2009 10:13']Can you attach a sample workbook?[/quote]
    Thanks for your response. I managed to resolve this by creating a calculated criteria that uses '=D9="ALPHA"'. I assume this is a microsoft bug/feature as it should work with a simple criteria 'ALPHA'. Andy.

  4. #4
    Lounger
    Join Date
    Sep 2008
    Posts
    49
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Both Advanced Filter and the database functions (e.g. DSUM) treat naked text (e.g. "Cat") in the criteria fields as if there were wildcards.
    "Cat" returns the same as "=Cat*".

    I suspect that it comes from a blank in the criteria field, being treated as ALL. "" is the same as "=*"

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you want an exact match, you need to use a criterion like:
    ="=my value"
    in the criteria range.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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