Dynamic Array formulas

How to fix #SPILL! error with Excel VLOOKUP, INDEX MATCH and SUMIF

It is sad enough when a brand-new feature refuses to work in your Excel. But even more frustrating is when a good old thing stops working all of a sudden, and you are receiving an error for a formula that worked perfectly for years. This tutorial will teach you how to fix a #SPILL error in some popular formulas. Continue reading

Spilling in Excel: what it means and how to use it

The recent dynamic array update has bought a wealth of inspiring new capabilities. But all is centered around the core concept of "spilling". So, let's take a close look at this feature and how you can leverage it to improve your Excel experience. Continue reading

Excel spill range explained

Spilling is one of the new features introduced in Excel 365 as part of the dynamic arrays functionality. Understanding the spill range concept is the focus of this tutorial. Continue reading

Implicit intersection and @ operator in Excel 365 and older versions

You have the feeling you know everything about your Excel workbooks, and then a @ character appears from nowhere in the beginning of your formulas. What does this mean? And how does it work precisely? Continue reading

Excel #SPILL! error - causes and fixes

Just imagine this: you upgraded to Microsoft Office 365 with the latest Excel updates and for some reason the tried and tested formulas you've been using for years have suddenly stopped working. Whatever you do, you are now getting a #SPILL error. Does anyone know what it means? Continue reading

Set up dependent drop-down list for multiple rows in Excel

The introduction of dynamic arrays has made our lives as Excel users a lot easier. Among many other things, they significantly simplify the creation of dynamic drop down lists that you can copy across multiple rows. Continue reading

How to make a dynamic dependent dropdown list in Excel an easy way

Creating a simple drop down list in Excel is easy. Making a cascading drop-down has always been a problem. But not any more! The introduction of dynamic arrays in Excel 365 provided a fast and easy solution. Continue reading

Excel dynamic arrays, functions and formulas

Due to the revolutionary update in the Excel 365 calculation engine, array formulas become very straightforward and understandable for everyone, not just for super users. The tutorial explains what dynamic arrays are, and how they can make your worksheets more efficient. Continue reading

Excel FILTER function with formula examples

The introduction of the FILTER function in Excel 365 has become a long-awaited alternative to the conventional methods. Unlike the Filter feature that needs to be re-applied with each data change, Excel formulas recalculate automatically, so you need to set up your filter just once! Continue reading