https://exceljetsb.pages.dev/posts/array-formulas-with-and-and-or-logic/
Array Formulas With And And Or Logic