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.

Hi

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

--
Regards

Roger Govier


"Vadhimoo" <(E-Mail Removed)> wrote in message
news:52AB9197-12E2-435B-906A-(E-Mail Removed)...
>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.

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" <(E-Mail Removed)> wrote in message
news:52AB9197-12E2-435B-906A-(E-Mail Removed)...
> 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.