Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008
    Location
    Northwest Indiana
    Posts
    3

    Unanswered: Advance Filter - "does not end with"

    I would like to use advance filter on a column with 4 character text entries. I want to see all entries that do not end with "RD". I can do this with the regular filter on, but I want to extract a list using the advance filter.

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Make sure the column has a meaningful header in the first row. I have no idea what your data represesnts so let's say the header is Characters.

    The criterion in the criteria range you would use is:

    Characters
    <>*RD


    The * is a wildcard which represents any number of characters.

    Hope that helps...
    Last edited by Colin Legg; 12-30-09 at 05:54.

  3. #3
    Join Date
    Oct 2008
    Location
    Northwest Indiana
    Posts
    3

    advance filter -"dows not end with"

    This worked perfectly. Thank you.

  4. #4
    Join Date
    Jan 2010
    Posts
    2
    Hello,

    you are going wrong you using only "RD" but actual code is " <>*RD "
    And you have to also make sure to use * .

    Good Luck!!!

Posting Permissions

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