GMC The Macro Man
Board Regular
- Joined
- Mar 23, 2023
- Messages
- 64
- Office Version
- 2021
- Platform
- Windows
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
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