How to filter as you type without VBA in Excel

How to filter as you type without VBA in Excel

Excel has rich resources on filtering as expected from a spreadsheet software. However, the functionality may lack of fanciness in a business software, like filtering on-the-fly as users are typing. Fortunately, Excel has enough customization tools to add such a...

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...