by Ilker | Feb 20, 2019 | Excel Tips & Tricks
Dynamic arrays can populate a range of cells from the values of an array. With dynamic arrays, any formula that returns an array of values will spill the results into the adjacent empty cells automatically. You can create tools like interactive pricing applications...
by Ilker | Apr 21, 2021 | Excel Tips & Tricks
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...
by Ilker | Mar 30, 2021 | Excel Tips & Tricks
Even though Pivot Tables are very useful in data management and analysis, they don’t automatically update when you make changes. In this guide, we’re going to show you how to replace pivot tables with dynamic array formulas in Excel. Download Workbook Simple...
by Ilker | Feb 5, 2021 | Blog
Dropdown-style user interface controls are fairly common in online forms. This type of controls help with data organization and help users enter data faster by limiting the users to a set of predetermined options. Dynamic dropdowns take the user experience one step...
by Ilker | Nov 23, 2020 | Excel Tips & Tricks
In this article, we are going to show you how to create a dynamically changing calendar in Excel. Download Workbook Populate variables First step is creating the variables to be used in the formulas. These variables need to provide the present day information so that...
by Ilker | Jul 11, 2019 | Excel Formulas, Excel Tips & Tricks
A dynamic drop down (also known as a dependent drop down) is a term for drop downs with a dynamic list. The list items of a dynamic drop down get updated according to another input which is usually another drop down as well. A common example is to have lots of items...
by Ilker | Jul 10, 2019 | Excel Tips & Tricks
A common way to populate lists or tables in Excel is using the INDEX function. However, you need to create a helper column or row, to define row and column numbers for the INDEX function. This way, the INDEX can populate return the values into the corresponding cells....
by Ilker | Jul 2, 2019 | Excel Tips & Tricks
Excel doesn’t have a built-in method to sort data randomly. Instead, you need to rely on formulas to sort a list of values randomly. Before dynamic array formulas, you needed to build a structure of formulas and helper columns to achieve this. Thanks to the...
by Adam | Apr 12, 2019 | Press Release
Cambridge, MA, April 15, 2019 – Pagos, Inc. has announced the release of the SpreadsheetWEB version 6.9, now supporting dynamic array formulas and allowing users to download their information with one click.Moving away from the traditional array formulas, Microsoft...
