How to create dynamic charts in Excel

In this guide, we’re going to show you how to create dynamic charts in Excel using dynamic arrays. Download Workbook Even though Excel doesn’t have built-in support for dynamic charts, there are multiple ways to do this. The traditional methods are using Excel...
How to consolidate text by a condition in Excel

How to consolidate text by a condition in Excel

In this article, we are going to show you how to consolidate text by a condition in Excel. Download Workbook Please note that we will be using the new dynamic array functions UNIQUE and FILTER in this post. These functions currently are only available to Office 365...