Filter with Multiple Criteria

[GMC The Macro Man]

Hi there
I have a table which I use to pull data through using the =FILTER function - this is what I'm using "=FILTER(MrExcel,MrExcel[Dept]=A4)", The TABLE is called MrExcel .
I have a drop down list in A4 (Dept) that I select and it will produce the table underneath. However I now want to filter it further by Region or Role or UserName (B4-D4) but I cannot get the =FILTER function to work properly by using the AND/OR (*/+) within the formula
I want to have drop down lists in A4-D4 and this will allow me to select ANY permutation I want to be returned in the table.
Is the =FILTER function the right way to do this or should i be using something else.

Thanks in Advance

 

[Fluff]

You can do that like

=FILTER(MrExcel,(IF(A4="",1,MrExcel[Dept]=A4))*(IF(B4="",1,MrExcel[Region]=B4)),"")

 

[GMC The Macro Man]

You can do that like

=FILTER(MrExcel,(IF(A4="",1,MrExcel[Dept]=A4))*(IF(B4="",1,MrExcel[Region]=B4)),"")

Hi Fluff, apologies for the delay in getting back to you but I just want to say many thanks.. AGAIN... for solving this problem for me. You are an absolute STAR

 

[Fluff]

Glad to help & thanks for the feedback.