Using the Advanced Filter

  • Thread starter Thread starter carlos
  • Start date Start date
C

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
 
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
 
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$&
 
Back
Top