autofilter

Tyre · May 10th, 2002, 01:27 PM

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)

Sam40mUK · May 10th, 2002, 04:24 PM

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

Chris Davison · May 12th, 2002, 10:09 AM

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 !

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 01:27 PM	#1
Tyre 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)

May 10th, 2002, 04:24 PM	#2
Sam40mUK 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

May 12th, 2002, 10:09 AM	#3
Chris Davison 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 !