Select Page

## Function: INDIRECT

The Excel INDIRECT function is a Lookup & Reference formula that returns the reference specified by a text string. It is useful for when you want to convert text strings into valid references. In this guide, we’re going to show you how to use the Excel INDIRECT...

## How to unhide sheets in Excel and restore the worksheets tab

If you lost a worksheet or cannot find the worksheet tabs section in your workbook, fear not! In this guide, we’re going to show you how to unhide sheets and various methods to restore disappeared worksheet tabs.   Unhide Sheets in Excel Excel allows hiding...

## Single operator

With the dynamic arrays concept, formulas that return an array can spill the results to the neighboring cells automatically. However, this behavior conflicts with legacy implicit intersection formulas that use ranges (arrays). For the sake of backward compatibility,...

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

## All you need to know about Excel’s new Spill feature

The term spill in Excel’s literature is defined as populating multiple cells with a single formula. With the announcement of the dynamic arrays in September 2018, Excel formulas can now return (spill) an array of values into neighboring cells by starting with...

## Dynamic Arrays

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

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

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

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