Filter Formula ignoring data

[Anonymous321]

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?

 

[Fluff]

Hi & welcome to MrExcel.
Without knowing what your data looks like, this may not be the problem, but are A2 & C3 correct? or should they both be on the same row in the Visual sheet?

 

[Anonymous321]

Hi & welcome to MrExcel.
Without knowing what your data looks like, this may not be the problem, but are A2 & C3 correct? or should they both be on the same row in the Visual sheet?

Yeh sorry but I think I'll be able to show the data. A2 and C2 are correct. The filter is filtering data from formulas If you know what I mean. As in instead of the of the data its filtering just merely saying 'Fantasy Author', there's a formula in that cell that leads to that text to be presented. Again, sorry If im not explaining this very well

 

[Fluff]

Your formula is not using A2 & C2, it's using A2 & C3

 

[Anonymous321]

Your formula is not using A2 & C2, it's using A2 & C3

Sorry that was a typo. A2 and C3 are correct

 

[Fluff]

In that case I would need to see your data, can you post a sample showing the problem.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.