AutoFilter, n filterlist elements in 1 cell

R

rsenden

if i would want to use AutoFilter to browse the sheet on keywords (whic
appear in the AutoFilter-list), can I enter more than 1 keywords in
row's column? I would like to avoid having to use more than 1 row t
attach N keywords to that particular row
 
D

Debra Dalgleish

To find one of multiple keywords per cell in a column, choose the Custom
option in the AutoFilter dropdown.

In the Custom dialog box, from the first dropdown, choose Contains
Type the keyword in the text box, and click OK
 
Top