Excel Functions

Excel SEQUENCE Function

Pinterest LinkedIn Tumblr

The Excel SEQUENCE function helps us to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. In MS-Excel SEQUENCE function is categorized under MATH & TRIGNOMETRY function.

Purpose of Excel SEQUENCE Function

It helps replace the need to use the ROW or COLUMN function to return an array of values for use in other functions. rows Here we need to specify the number of rows to be returned.

Return value

SEQUENCE function returns an array of sequential functions.

Syntax

=SEQUENCE(rows,[columns],[start],[step])

Arguments

ArgumentsDescriptionRemarks
rowsThe number of rows to return.Mandatory
[columns]The number of columns to return.  If excluded, it will return a single column.Mandatory
[start]The first number in the sequence.  If excluded it will start at 1.Optional
[step]The amount to increment each subsequent value.  If excluded, each increment will be 1.Optional

Usage notes

  • Any missing optional arguments will default to 1.
  • If any of the arguments is not a numeric value, you will get a #VALUE! error.
  • This function will return an array, which will spill if it’s the final result of a formula

Availability

Available for office 365.

Related Posts

Write A Comment