Explanation TOROW takes a range/array and converts it into a single row. Example Syntax =TOROW(array, [ignore], [scan_by_column]) array - The range/array of cells we want to convert into a single…

Explanation CHOOSEROWS is a function that allows you to choose and return only specific rows from a range/array. The result returns as a dynamic array. CHOOSEROWS is a new Excel…

Explanation CHOOSECOLS is a function that allows you to choose and return only specific columns from a range/array. The result returns as a dynamic array. CHOOSECOLS is a new Excel…

Explanation HSTACK is a function that allows you to stack 2 or more arrays horizontally. An array could be a single cell, row, column, or any combination of rows and…

Explanation VSTACK is a function that allows you to stack 2 or more arrays vertically. An array could be a single cell, row, column, or any combination of rows and…

What's a LAMBDA? LAMBDA is not just another Excel function - It is the mother of all Excel functions. Why is LAMBDA so special?  LAMBDA can be used to create…

LET Function Explained LET function allows us to create names within a function, and assign values and calculations to these names so that they can be later re-used in the…

SEQUENCE Function Explained SEQUENCE function creates an array of sequential values. It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the user…

Explanation RANDARRAY is a function that generates an array of random numbers. It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the…

FILTER Function Explained FILTER returns a filtered list of values from a range that meet a certain criteria. It is part of the Excel Dynamic Array Formulas. This is a…