![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Board Regular
Join Date: Feb 2002
Location: Regina, Canada
Posts: 79
|
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 |
|
Board Regular
Join Date: Mar 2002
Location: North Wales Coast, UK
Posts: 95
|
Evening,
Perhaps you need to consider using the wildcard function? Try using Contains *your search* Hope this helps S |
|
|
|
|
|
#3 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Millbank, London, UK
Posts: 1,790
|
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 ! |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|