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

WRAPCOLS Function

The WRAPCOLS function is one of the lookup and reference functions. It is used to wrap a row or column vector by columns after a specified number of values.

Syntax

WRAPCOLS(vector, wrap_count, [pad_with])

The WRAPCOLS function has the following arguments:

Argument Description
vector Is used to set the vector or reference to wrap.
wrap_count Is used to set the maximum number of values for each column.
pad_with Is used to set the value with which to pad. Defaults to #N/A.

Notes

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

How to apply the WRAPCOLS function.

Examples

The figure below displays the result returned by the WRAPCOLS function. It wraps the row in range A1:F1 to an array in range A3:C5 by columns.

WRAPCOLS 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