Forum Discussion
Solved
Can Excel =filter function include a 'criteria range' for multiple criteria of one column?
Hello Everyone, I am trying to use =filter formula to filter multiple criteria for a single column as below, by using a "criteria range": However it is not working and return an #N/A ...
Can you please explain HOW exactly this formula works? It is so elegant but I cannot decode the steps it takes to get the result.