Explanation
In this example, the goal is to repeat a sequence of numbers.
This is a useful way to create repeating sequences of numbers by itself.
The evaluation of SEQUENCE works like this:
The final result is a zero-based sequence of 12 numbers.
The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
…
MOD Function
The Excel MOD function returns the remainder of two numbers after division.
For example, MOD(10,3) = 1.
The result of MOD carries the same sign as the divisor.
Related videos
The SEQUENCE function
