Custom Auto Filter

V

Vadhimoo

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.
 
R

Roger Govier

Hi

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

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)
 

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

Top