Advanced Filters - 'or' function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large worksheet and wish to perform an advanced filter on the data.

Can anybody tell me if you can create a single advanced filter which will
look for data in two columns using the 'or' function. For instance, to
filter out those records with a value of greater than 5 in column C 'or' a
value greater than 5 in column D?

I can create advanced filters but have never asked it to look at multiple
values before.

Thank you.
Louise
 
Try this:

In the criteria range for the Advanced Filter, criteria in the same row
must ALL be met (equivalent to "AND" in SQL). Criteria in contiguous rows
are the equivalent of "OR" in SQL.

Example:
This criteria indicates that only items with Val1>5 OR items with Val2>5
will be displayed.

Val1 Val2
5 (blank)
Click to expand...
(blank) >5

Note: Implicit in that criteria is that items with BOTH Val1>5 and Val2>5
will be displayed.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Thanks very for your response.

At first glance, it seems to have worked. If we have any problems with the
data, I might need more help.......

Thanks again.
Louise
 
Back
Top