Voci con l'etichetta :
Voci con l'etichetta :
Provalo nel cloud

EXPAND Function

The EXPAND function is one of the lookup and reference functions. It is used to expand a range of data (array) by adding rows and columns.


EXPAND(array, rows, [columns], [pad_with])

The EXPAND function has the following arguments:

Argument Description
array The range of cells to be expanded.
rows The number of rows in the returned array. Although this is a required argument, if omitted, rows will not be added and the number of columns must be specified.
columns An optional argument identifying the number of columns in the returned array. If omitted, columns will not be added and the number of rows must be specified.
pad_with The value to fill in the added cells. #N/A is the default value.


Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the EXPAND function.


The figure below displays the result returned by the EXPAND function.

EXPAND Function

Alla pagina precedente
Try now for free Try and make your decision No need to install anything
to see all the features in action