Turns out half my old formulas were just dynamic arrays in disguise, written the long way.

Check each column individually, and put a 1 or a 0 in a cell below each column. Then test that row of values for a 1. Not pretty, but functional.

An array is made when items are arranged in rows and columns. This array has 12 counters. Every row in an array is the same length and every column in an array is the same length. This array has 4 ...

Have you ever found yourself staring at a massive Excel spreadsheet, wondering how to pull the right information from multiple columns without losing your mind? If so, you’re not alone. Whether you’re ...