Skip to content
REFERENCE

U.SEQUENCE

Summary

Creates a sequence of numbers

Syntax

=U.SEQUENCE(start_val, [interval], [length], [skip])

Parameters

Parameter Required Description
start_val Yes The first number in the sequence to be created. Set to zero if invalid
[interval] No The difference between successive numbers in the sequence. The difference between row numbers of a matrix result can be provided as a 2nd value. Default is 1 if not provided
[length] No The number of values the resulting sequence will contain. The number of values in each row of a matrix result can be provided as a 2nd value. Default is size of calling range if not provided
[skip] No The values to omit from the sequence if they otherwise would occur

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.SEQUENCE(B60,"x"&1.2,3,B60)

=U.SEQUENCE(C5,C6,C7)

=U.SEQUENCE(C5,C6,C7,C13)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.