Advanced Filters - 'or' function

[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

 

[Guest]

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)

(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

 

[Dave Peterson]

Put your headers in K1:L1 (say)
In K2, put:

5 In L3 (leave L2 empty), put:
5

Debra Dalgleish explains it with pictures:
http://contextures.com/xladvfilter01.html#CriteriaRange

 

[Guest]

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