Selecting more than one filter values

[jamex]

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

[Ardus Petus]

Use an advanced filter

--
AP

"jamex" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> 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]

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