Selecting more than one filter values

I filtere a column having A,B,C,R groups.
When i click A then rows related to A are selected and the rest is hidden as we know it. But how to select A and R at the same time so i can view both A and R groups.

Regards...

Use an advanced filter

--
AP

"jamex" <jamex.24uvyy_1142669700.7074@excelforum-nospam.com> a écrit dans le
message de news:jamex.24uvyy_1142669700.7074@excelforum-nospam.com...
>
> I filtere a column having A,B,C,R groups.
> When i click A then rows related to A are selected and the rest is
> hidden as we know it. But how to select A and R at the same time so i
> can view both A and R groups.
>
> Regards...
>
>
> --
> jamex
> ------------------------------------------------------------------------
> jamex's Profile:
http://www.excelforum.com/member.php...o&userid=32243
> View this thread: http://www.excelforum.com/showthread...hreadid=523855
>

You can have two criteria in data|autofilter.

Choose Custom from the dropdown filter arrow.

You'll see a couple of spots where you can specify your criteria (and you can
use and/or logic when you do it).

Click on those dropdowns and you'll see lots of things that may help:
Begins with
contains
ends with
is greater than
is greater than or equal
equal to

and a few more.

But it is limited to just two criteria.

jamex wrote:
>
> I filtere a column having A,B,C,R groups.
> When i click A then rows related to A are selected and the rest is
> hidden as we know it. But how to select A and R at the same time so i
> can view both A and R groups.
>
> Regards...
>
> --
> jamex
> ------------------------------------------------------------------------
> jamex's Profile: http://www.excelforum.com/member.php...o&userid=32243
> View this thread: http://www.excelforum.com/showthread...hreadid=523855

--

Dave Peterson