Select Page

## How to random sort in Excel using dynamic array functions

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

## How to refresh stock data in Excel

Excel can get the stock market data from 60 different stock exchanges around the world. However, this information will not refresh automatically, and currently you need to refresh stock data manually, or write a VBA code to automate the process. In this article, we...

## How to Get Excel Stock Quotes

Excel is one of the best platforms to do stock quote analysis. However, you traditionally had to pull this data either manually, or using third party tools. Now, you can do this using built-in Excel features if you are running Office 365. In this article, we are going...

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

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