How to add extra criteria

[Scorpion Steve]

Hey!
I am trying to find out how to "add" another criteria when using the advance filter option.
for example
At this time: Citeria Range: $B$4:$B$5
I would like to have $C$4:$C$5 on.
What is needed to make this happen?

Citeria Range: $B$4:$B$5 as well as $C$4:$C$5
Thanks

 

[anandvarma]

Hey Try this

ADD ANOTHER ROW BELOW THE EXISTING CRITERIA AND PUT $C$4,$C$5 AND IN THE ADVANCE FILTER OPTION THIS TIME YOU SELECT THE CRITERIA BOTH ROWS
IT WILL WORK

 

[Aladin Akyurek]

Hey!
I am trying to find out how to "add" another criteria when using the advance filter option.
for example
At this time: Citeria Range: $B$4:$B$5
I would like to have $C$4:$C$5 on.
What is needed to make this happen?

Citeria Range: $B$4:$B$5 as well as $C$4:$C$5
Thanks

Wouldn't that be:

$B$4:$C$5