Back to Browse

Returning multiple rows with AND / OR conditions using ARRAYFORMULA

3.8K views
Dec 15, 2021
9:37

This video helps you overcome a common limitation of arrayformula and helps you use AND and OR operators without any pain. This hack can be used in endless combinations and can be a life saver when you need it the most. 0:00 Introduction 0:28 What are AND and OR operators 3:34 How to use AND with Arrayformula? 6:54 How to use OR with Arrayformula?

Download

1 formats

Video Formats

360pmp412.3 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Returning multiple rows with AND / OR conditions using ARRAYFORMULA | NatokHD