Spill Range Operator

Spill Range Operator

With the introduction of the dynamic arrays and spill concepts, Microsoft has also released a spill range operator (#). This operator is designed to reference spill ranges dynamically. For example, the cell D3 has =UNIQUE(B3:B16) formula which spills the return values...
Function: SINGLE

Function: SINGLE

The Excel SINGLE function is a Lookup & Reference formula that returns a value using implicit intersection. In this guide, we’re going to show you how to use the Excel SINGLE function and also go over some tips and error handling methods. The Dynamic Array...
Function: RANDARRAY

Function: RANDARRAY

The RANDARRAY function is a Math & Trigonometry formula that creates an array of randomly generated numbers. In this guide, we’re going to show you how to use the RANDARRAY function and also go over some tips and error handling methods. The Dynamic Array functions...
Function: SORTBY

Function: SORTBY

Excel SORTBY function is a lookup and reference formula that sorts the values in a range or array based on the values in a corresponding range or array. In this guide, we’re going to show you how to use the Excel SORTBY function and also go over some tips and error...
Function: SEQUENCE

Function: SEQUENCE

The SEQUENCE function is a Math & Trigonometry formula that generates a list of sequential numbers in the form of an array or range. In this guide, we’re going to show you how to use the SEQUENCE function and also go over some tips and error handling methods. The...
Formula: FILTER

Formula: FILTER

The Excel SORT formula is a lookup and reference function that filters a range or array. The FILTER function is one of the newest Dynamic Array functions which are release with Excel 2019. In this guide, we’re going to show you how to use the Excel FILTER formula and...
Function: SORT

Function: SORT

The Excel SORT function is a lookup and reference formula that returns a list of unique values from a list or range. The SORT function is one of the newest Dynamic Array functions which are release with Excel 2019. In this guide, we’re going to show you how to use the...
Function: UNIQUE

Function: UNIQUE

The Excel UNIQUE function is a lookup and reference formula that returns a list of unique values from a list or range. This formula is one of the newest Dynamic Array functions to be released with Excel 2019. In this guide, we’re going to show you how to use the Excel...