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...
Protecting Your Excel Charts and Dashboards with Array Formulas
Has this ever happened to you?
You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...
