Custom Auto Filter
 

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.

Custom Auto Filter
 

Hi

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

--
Regards

Roger Govier


"Vadhimoo" wrote in message
...
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.

Custom Auto Filter
 

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)

"Vadhimoo" wrote in message
...
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.