Soldato
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 | Layer Blog
How to filter Excel data by text, numerical value, and date, and how to use the FILTER function with multiple conditions and others like UNIQUE and SORT.
blog.golayer.io
Last edited: