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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split cells next to 1 cell 1
Cell data entering slow! 0
Excel does not accept text format! 0
check text in cell for at least one keyword from a list on anothersheet 4
Eliminate blanks while copy row and transpose 11
Trying to figure the formula 1
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Multiple conditional formating for one cell 2

Top