The order of advanced filtering

[greekkey]

Hi, there!

I am now trying advanced filtering. It's really a good tool when the filtering conditions are not so complex, for example, =a1 OR >b2; =a2 AND =b3. 

Is it possible to filter for the condition  (>a1 OR =a2) AND (>b1 OR =b2)?

[#2]

@greekkey 

In Advance Filter AND conditions are in the same row; OR conditions are in another rows. For example

gives

[#3]

@Sergei Baklan thank you for your reply! However, in your formula, I think the office will execute the filtering in the same line (AND), so the filter will be executed as (A=102 AND B=12) OR (A>107 AND B>19).

Please see the attached EXCEL, the two lines I added, which meet conditions a1 AND b2 / a2 AND b1, will be lost. 

In one word, is it possible to change the filtering order in advance filtering (let it filter the conditions in the same row first)?

[#4]

@greekkey 

Not sure I understood you correctly, perhaps you mean such conditions