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.

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

The Ultimate Excel Course & Advanced Excel Tricks Bundle ► https://bit.ly/2YibpiM

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1

Видео Excel FILTER Function - Meet ONE Condition ONLY - Strict OR Logic канала Computergaga