+ Reply to Thread
Results 1 to 5 of 5

Filter pivot for "Does Not Contain" to filter out 4 Character Strings

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2013
    Posts
    3,252

    Filter pivot for "Does Not Contain" to filter out 4 Character Strings

    I have a huge pivot. In my "Description" column I have thousands of entries like "5CIG", or "EFTR", of "5168". Is there a way to configure the "Does Not Contain" filter to filter out if description is only a 4 character string? I'm open to either a VBA or non VBA solution.
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,214

    Re: Filter pivot for "Does Not Contain" to filter out 4 Character Strings

    untested: have you tried applying label filter with "not between" and both start / end values of ????

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2013
    Posts
    3,252

    Re: Filter pivot for "Does Not Contain" to filter out 4 Character Strings

    Sorry it took me so long to get back. I tried the trick of using "not between" and start/end values of ????, and it appears to work. I also tried "Contains", using ?????*. I thought 4 question marks and an asterisk would mean "5 characters or more", but that left the 4 character strings present.

    thanks for showing me another way around this. I'll have to do a comparison of the data sets to determine if one solution is more right than the other. "Appears" and "Is" can be worlds apart.

  4. #4
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    1,214

    Re: Filter pivot for "Does Not Contain" to filter out 4 Character Strings

    As you have typed it, i.e. five ? and * , it should exclude codes <= 4 chars... 4 ? and * would still pick up 4 char codes

    I went with the "between" route as I wasn't sure if you had 1, 2 & 3 char combos that you wanted to persist in the filtered view -- the between clause will only exclude 4-char values.

  5. #5
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2013
    Posts
    3,252

    Re: Filter pivot for "Does Not Contain" to filter out 4 Character Strings

    That's an important distinction. For this instance, I really want to get rid of anything 4 characters or less, but being able to get rid of ONLY 4 character strings can be hugely helpful. Thanks for showing me the way.

+ 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