Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: autofilter

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Regina, Canada
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to autofilter a column, in which each cell contains a list of several items.
    I go to Customdoes not containand one of the items in the list.
    autofilter does not filter out all the cells containing the item.
    I could not find any info on limitations in a cell, using autofilter.
    (if each item in the list is in a seperate cell the filter works)

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    North Wales Coast, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Evening,
    Perhaps you need to consider using the wildcard function?
    Try using Contains *your search*
    Hope this helps
    S

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Tyre,

    for the instances where the unwanted rows are still visible, is the row number indictor blue (ie indicating it's within the filtered info) ?

    if it's not, it means that the row was not included within the filter range : this would suggest that you have some blank rows in your data and the autofilter is just being applied to the first block of info (fix by resetting your auto filter: either highlight your entire range of info or just highlight the respective columns to capture everything)

    Hope this helps,
    Chris

    One observation : I was just replicating a list of names :

    Chris
    Chris_
    _Chris
    Harry
    Sally
    John
    Paul
    George
    Ringo

    When I applied autofilter, in the "is equal to" options there was only a single instance of "Chris".... not 3.

    Choosing this option brought back all 3 instances of "Chris", with the leading and trailing spaces.

    I wasn't expecting this !

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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