Pragmatism vs. purity in Excel

One of the greatest things about Excel is that with its endless array of tools and commands it almost always offers multiple ways of achieving a certain goal.

Some Excel purists (particularly those that are familiar with Array formulas), will almost always opt in favor of formulas, whereas a pragmatic will always choose the fastest way (whatever it may be). The following example shows pragmatic and pure approaches to solving the same problem.