Data Transformation – Excel Array Solution
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages. Well although...
Removing Array Formulas Around Your Excel Charts and Dashboards
Yesterday I posted a quick tutorial on protecting your Excel Dashboard Charts by using Array Formulas.
You can check out that posting here:
Protecting Your Excel...
