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



Louise wrote:

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

--

Dave Peterson