Conditional AutoFilter?

  • Thread starter Thread starter Gregg Stone
  • Start date Start date
G

Gregg Stone

Is there an easy way to get three OR conditions on a Custom AutoFilter? If
not, can you suggest a simple way to accomplish this in another fashion?

In other words, filter this column of data and display only those values
that are ConditionA OR ConditionB OR Condition C.

TIA!
 
Gregg
You will have to use Advanced Filter. Look it up in Help. Post back if
you need more. HTH Otto
 
One option is to add a column to the table, and use a formula to check
for the criteria. For example, if you want to filter for three
salespeople, whose names are in column B, enter the following formula in
row 2, and copy down to the last row of data:

=COUNTIF($J$1:$J$3,B2)

Where the three names are entered in cells J1:J3.

Add a heading to the column with the new formula, then filter this
column for rows that contain a 1.
 
Back
Top