Selecting more than one filter values

J

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 i
hidden as we know it. But how to select A and R at the same time so
can view both A and R groups.

Regards..
 
D

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