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)
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)