Function: TRANSPOSE

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

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

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

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

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