advanced filter - OR vs AND

[lezawang]

Hi
Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this

I understood all the above but what I do not understand, when I use a regular filter to filter Country to USA and UK and when I use filter to filter Quarter to Q4 and Q1. How that filter is AND ? AND what and what? and Why the above filter is considered as OR?

source:

https://www.excel-easy.com/examples/advanced-filter.html

 

[DanteAmor]

Let's say it's a combined filter of OR and AND


Filter the

the country USA AND also be Q4

OR

the country is UK AND also be Q1

-----------
The OR in the advanced filter you put in lines
In C2 = USA OR C3 = UK




The AND in the advanced filter you put in Columns
C2 = USA AND D2 = Q4

 

[MARK858]

@lezawang, you'll possibly find the Contextures link below easier to understand than the excel-easy link plus if you scroll down the page you can download an example workbook (see the AndOr tab for this actual question).


https://www.contextures.com/xladvfilter01.html