Advanced filter: criteria in non-adjacent ranges?
 

Hi,
Can this be done?
I need to be able to construct filter from 2 simple criteria ranges (say 3
by 3 each) but they sit in different locations (on the same sheet though). I
suppose, I could temporarily merge them in some hideaway prior to use but
I'm trying to avoid it.

TIA
Paul

Advanced filter: criteria in non-adjacent ranges?
 

See possible answer to your later posting if this question.

--
Regards,
Tom Ogilvy

"count" wrote in message
...
Hi,
Can this be done?
I need to be able to construct filter from 2 simple criteria ranges (say 3
by 3 each) but they sit in different locations (on the same sheet though).
I
suppose, I could temporarily merge them in some hideaway prior to use but
I'm trying to avoid it.

TIA
Paul