The order of advanced filtering

%3CLINGO-SUB%20id%3D%22lingo-sub-2534207%22%20slang%3D%22zh-CN%22%3EThe%20order%20of%20advanced%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2534207%22%20slang%3D%22zh-CN%22%3E%3CP%3EHi%2C%20there!%3C%2FP%3E%3CP%3EI%20am%20now%20trying%20advanced%20filtering.%20It's%20really%20a%20good%20tool%20when%20the%20filtering%20conditions%20are%20not%20so%20complex%2C%20for%20example%2C%20%3Da1%20OR%20%26gt%3Bb2%3B%20%3Da2%20AND%20%3Db3.%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20filter%20for%20the%20condition%26nbsp%3B%26nbsp%3B(%26gt%3Ba1%20OR%20%3Da2)%20AND%20(%26gt%3Bb1%20OR%20%3Db2)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2534207%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2534365%22%20slang%3D%22en-US%22%3ERe%3A%20The%20order%20of%20advanced%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2534365%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1098213%22%20target%3D%22_blank%22%3E%40greekkey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Advance%20Filter%20AND%20conditions%20are%20in%20the%20same%20row%3B%20OR%20conditions%20are%20in%20another%20rows.%20For%20example%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20410px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294763i08C1113B28707DDF%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Egives%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20169px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294764i60A6926A4184ADE8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2545038%22%20slang%3D%22zh-CN%22%3ERe%3A%20The%20order%20of%20advanced%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2545038%22%20slang%3D%22zh-CN%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%20thank%20you%20for%20your%20reply!%20However%2C%20in%20your%20formula%2C%20I%20think%20the%20office%20will%20execute%20the%20filtering%20in%20the%20same%20line%20(AND)%2C%20so%20the%20filter%20will%20be%20executed%20as%20(A%3D102%20AND%20B%3D12)%20OR%20(A%26gt%3B107%20AND%20B%26gt%3B19).%3C%2FP%3E%3CP%3EPlease%20see%20the%20attached%20EXCEL%2C%20the%20two%20lines%20I%20added%2C%20which%20meet%20conditions%20a1%20AND%20b2%20%2F%20a2%20AND%20b1%2C%20will%20be%20lost.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20one%20word%2C%20is%20it%20possible%20to%20change%20the%20filtering%20order%20in%20advance%20filtering%20(let%20it%20filter%20the%20conditions%20in%20the%20same%20row%20first)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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)?

3 Replies

@greekkey 

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

image.png

gives

image.png

 

@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)?

 

@greekkey 

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

image.png