|
REPEAT function
Copies a range/array consisting of a rectangular block of cells one or more times vertically and/or horizontally by duplicating thr block of cells.
REPLACE is a multi-threaded, non-volatile array function.
REPEAT Syntax
REPEAT (RangeArray, [VerticalRepeats] [,HorizontalRepeats])
RangeArray
Array, Table, Range or Spill reference to duplicate
VerticalRepeats (Optional, default=1)
The number of times to stack a copy of the input RangeArray vertically above one another.
HorizontalRepeats (Optional, default=1)
The number of times to stack a copy of the input RangeArray horizontally alongside one another.
REPEAT Examples:
.png)
.png)
Whereas the REPT function repeats a string of text by concatenating it to itself n times, the REPEAT function repeats a string of text by copying it to adjacent cells n times.
|
