Anonymous321
New Member
- Joined
- Oct 12, 2021
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
I've set up a filter formula to filter two lots of columns (e.g. filter Fantasy Authors and of those fantasy authors filter the men). However the filter doesn't want to do this and instead of filtering Male Fantasy authors (like in the example) it comes up blank. If I get the same formula to study only one of the columns it works fine. I'm not sure if I've explained this very well but this is the formula I'm using
=FILTER(All!B7:L1761,((All!C7:C1761=Visual!A2)*(All!D7:D1761=Visual!C3)),"")
Any ideas?
=FILTER(All!B7:L1761,((All!C7:C1761=Visual!A2)*(All!D7:D1761=Visual!C3)),"")
Any ideas?