Excel FILTER Function - Meet ONE Condition ONLY - Strict OR Logic

In this video, we use the FILTER function in Excel to return a list of names if just one condition is met. We do not want the FILTER function Or logic, because that will return the names if one or more conditions are met. For our example, it must be just one. This video will show how to do this and also explain how this works. Download the Excel workbook from the video here - https://bit.ly/2OBiLx6 The video timings are: 00:00 - Introduction 00:34 - FILTER function with strict OR logic 01:54 - Check the formula updates correctly 02:09 - Difference between FILTER function OR criteria and strict OR logic 02:53 - Explanation of how the formula works 04:24 - Closing words If you have more than two conditions, the formula shown as the pinned comment works. I cannot enter it here as YouTube descriptions do not allow the use of angled brackets. The formula uses the classic OR logical operator of + and then tests that the result is equal to 1.