|
- Implicit intersection operator: @ - Microsoft Support
If the value is a range, then return the value from the cell on the same row or column as the formula If the value is an array, then pick the top-left value With the advent of dynamic arrays, Excel is no longer limited to returning single values from formulas, so silent implicit intersection is no longer necessary
- Guidelines and examples of array formulas - Microsoft Support
An array formula is a formula that can perform multiple calculations on one or more items in an array You can think of an array as a row or column of values, or a combination of rows and columns of values Array formulas can return either multiple results, or a single result
- Array Function - Microsoft Support
Returns aVariant containing an array Syntax Array ( arglist ) The required arglist argument is a comma-delimited list of values that are assigned to the elements of the array contained within the Variant If no arguments are specified, an array of zero length is created Remarks
- Create an array formula - Microsoft Support
Create array formulas, often called Ctrl Shift Enter or CSE formulas, to perform calculations that generate single or multiple results
- Expand an array formula - Microsoft Support
To expand an array formula, select the current formula, the new data, the blank cells next to the new data, edit the formula, and press Ctrl+Shift+Enter
- Dynamic array formulas and spilled array behavior - Microsoft Support
Excel formulas that return a set of values, also known as an array, return these values to neighboring cells This behavior is called spilling Formulas that can return arrays of variable size are called dynamic array formulas Formulas that are currently returning arrays that are successfully spilling can be referred to as spilled array formulas
- IsArray Function - Microsoft Support
Returns a Boolean value indicating whether a variable is an array Syntax IsArray ( varname ) The required varname argument is an identifier specifying a variable Remarks IsArray returns True if the variable is an array; otherwise, it returns False IsArray is especially useful with variants containing arrays
- Use array constants in array formulas - Microsoft Support
Use array constants in array formulas or by themselves to save time, and when you need values that aren't in your workbook
|
|
|