Select Page

## How to get top values from a list or a table in Excel

Sorting data can substantially help organizing data and generating reports. In Excel, you can sort data with a single click using the Sort icons under the DATA tab. However, this is a permanent solution, meaning that the sorted data will remain that way, and you will...

## How to Generate a General Ledger (GL) List using SEQUENCE

Ledgers are crucial for keeping track of expenses, and managing the budget of any entity, be it a small house to an international company. Preparing a general ledger (GL) table can be a daunting task, especially when dealing with lots of category codes. If your table...

## How to generate a date list using the SEQUENCE function

Date lists are an important part of numerous Excel models. Excel can automatically recognize date-time values, format the cells, and generate a date list quickly with AutoFill or specific functions. However, date-time functions are focused on a generating a single...

## Function: TRANSPOSE

The TRANSPOSE Excel function is a Lookup & Reference formula that rotates a given range or array. Since the output of this formula is an array, you need to press the Ctrl + Shift + Enter (CSE) key instead of just pressing the Enter key when entering this function....

## Function: COLUMN

The Excel COLUMN function is a Lookup & Reference formula that returns the column number of a reference. In this guide, we’re going to show you how to use the Excel COLUMN function and also go over some tips and error handling methods.Supported versionsAll Excel...

## Function: ROW

The Excel ROW function is a Lookup & Reference formula that returns the row number of a reference. In this guide, we’re going to show you how to use the Excel ROW function and also go over some tips and error handling methods.Supported versionsAll Excel...

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