Artículos con :
Cerrar
Changelog
Cerrar
Artículos con :
Cerrar
Pruébelo en la nube

WRAPROWS Function

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

Syntax

WRAPROWS(vector, wrap_count, [pad_with])

The WRAPROWS 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 row.
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 WRAPROWS function.

Examples

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

WRAPROWS Function

Volver a la página anterior
Probar ahora gratis Pruebe y tome su decisión No se necesita instalar algo para
ver todas las posibilidades en la acción