Array
Data Transformation – Excel Array Solution
Learn how to combine the most recent Friday Challenge solutions into an Excel Array formula to solve the Data Transformation needs.
EXPLORE THE LIBRARY
Tag: Array
Array
Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria
In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that criteria. Three posts ago, you received a challenge
Excel tutorial
Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution
Hands off to Leonid 🙂 for this awesome solution with much Much BETTER formulas for a recent Friday Challenge. Here was the original Challenge: friday-challenge-pipeline-usage-chart Here was
Array
Challenge Answer – Negative AverageIf for Non-Continuous Range
In our last Friday challenge: Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous Ranges I wanted to see how you could also take into account when a us
Array
Removing Array Formulas Around Your Excel Charts and Dashboards
Excel dashboard protection tip and trick using array formulas
Array
Protecting Your Excel Charts and Dashboards with Array Formulas
Using Arrays can protect you from getting reference errors when users delete or insert rows or columns in your Excel Dashboards