Introducing Array Formulas, an Exotic Beast
One of the most obscure things about Excel has to be array formulas. Weird as snake’s suspenders, they are. We are familiar with the idea that a single formula in Excel occupies a single cell. If you want that formula to be in many cells, you simply copy it to those cells. It will adjust…