Excel Formula Help

[joey1211]

https://i.~ibb.co~/Bfgb9QV/Capture.png

I'm trying to filter some data so that if 'TRUE' is in either column B or C. So in this case Person4 would be hidden. Excel just keeps returning the same error.

Edit: I've now included a closing bracket at the the end of the formula but it still returns the same error.

Followed this guide...

Excel FILTER function and examples - Sheetgo

Learn how to use the Excel FILTER function to filter data by text, number, and date, with multiple conditions, and together with UNIQUE and SORT.

blog.golayer.io

 

[joey1211]

Replacing the semi colon with a comma cracked it... cheers!