To come up with a result as weird as this, you need to be using some equally mind-bending math – and indeed, this paradox comes to us from the world of set theoretic geometry. If that’s not familiar ...

Array formulas let you perform calculations across entire ranges of data in a single formula. Hence, you can handle lightning-fast lookups, filtering, and sorting with just one po ...