Custom Auto Filter

[Guest]

I want to show all the rows where it CONTAINS "a" or "b" or "c".
But In Excel : Filter->Auto Filter->(Custom)->Custom Auto Filter having
only two filter conditions. How can i filter above two conditions..?

Thanks in advance for your reply.

 

[Roger Govier]

Hi

In first condition box
left hand dropdown select Less than
right hand pane enter d

 

[Bob Phillips]

Create a helper column with a formula of

=OR(A2="a",A2="b",A2="c")

copy doiwn and filter on that column

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)