OR Statement with FILTER

[onthegreen03]

I am using a basic FILTER command (see below) which is working great. How can I convert the formula using OR so the result can be equal to $C$2 from the list in column B (Market Assessment tab), or the word "Portfolio" from that same list (same tab)? Said a different way, it would be filter list and return if equal to $C$2 or "Portfolio".

=FILTER('Market Assessment (2.3)'!$B23:$B34,'Market Assessment (2.3)'!$B$23:$B$34=$C$2)

 

[Eric W]

Try:

=FILTER('Market Assessment (2.3)'!$B23:$B34,('Market Assessment (2.3)'!$B$23:$B$34=$C$2)+('Market Assessment (2.3)'!$B$23:$B$34="Portfolio"))

 

[Norie]

Probably a better way but try this.

=FILTER('Market Assessment (2.3)'!$B23:$B34,(--('Market Assessment (2.3)'!$B$23:$B$34=$C$2)+(--('Market Assessment (2.3)'!$B$23:$B$34="Portfolio"))))

 

[onthegreen03]

Brilliant. Thank you!

 

[Eric W]

Glad we could help! Thanks for the feedback.