Using the Advanced Filter

[carlos]

I have 3 columns of data - A,B,C.

Column A has my Product Group Info (eg. Product Group A,
B,C,D...Z)

I would like to filter my spreadsheet to show me rows that
relate to Product Groups A,C,E,H,W,Z

Thanks in advance for your guidance

 

[Bernie Deitrick]

Carlos,

You can only use the autofilter to filter based on two values. To do
what you want, you would need to filter on a helper column that you
add, where the helper column has a formula like

=OR(A1="A", A1="C",......,A1="Z")

and then filter on that column looking for TRUE values.

HTH,
Bernie
MS Excel MVP

 

[Debra Dalgleish]

In the criteria area, enter a heading that matches the heading from the
Product Group column
In the cells below, enter the groups that you want to extract, e.g.:

ProdGroup
A
C
E
H
W
Z

Start the Advanced Filter, and for the Criteria range, select the
heading, and all cells with group names, e.g. Data!$M$1:$M$&