Scribd
Upload
89 views11 pages

Excel Sequence Function

The document is a sample workbook that demonstrates how to use the SEQUENCE function in Excel to automatically create number sequences. It provides 7 examples of using the SEQUENCE function to generate sequences in columns and rows, two-dimensional sequences, descending sequences, sequences that move vertically, sequences of Roman numerals, and sequences of random integers.

Uploaded by

sekolah-1223-cm8
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
89 views11 pages

Excel Sequence Function

The document is a sample workbook that demonstrates how to use the SEQUENCE function in Excel to automatically create number sequences. It provides 7 examples of using the SEQUENCE function to generate sequences in columns and rows, two-dimensional sequences, descending sequences, sequences that move vertically, sequences of Roman numerals, and sequences of random integers.

Uploaded by

sekolah-1223-cm8
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 11

Sample Workbook to SEQUENCE Function in Exce

The workbook shows how to use the SEQUENCE function to create a number series in Excel. Please note, these formulas
work in the latest versions of Excel 365 that support dynamic arrays.

Author
Last update
Tutorial URL

Examples:
• Create a number sequence in a column
• Create a number sequence in a row
• Make a two-dimensional number sequence
• Generate a descending sequence
• Force a two-dimensional sequence to move vertically
• Make a series of Roman numbers
• Create a sequence of random integers
mple Workbook to SEQUENCE Function in Excel
rkbook shows how to use the SEQUENCE function to create a number series in Excel. Please note, these formulas only
the latest versions of Excel 365 that support dynamic arrays.

Ablebits.com
10-Jul-20
Excel SEQUENCE function - create a number series automatically

a number sequence in a column


a number sequence in a row
two-dimensional number sequence
te a descending sequence
two-dimensional sequence to move vertically
series of Roman numbers
a sequence of random integers
Sequence
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
Sequence
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Sequence
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
Sequence
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
No. of rows 5
No. of columns 3
Start at 100
Step 10

Sequence moves vertically Sequence moves horizontally


#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
No. of rows 5
No. of columns 3
Start at 1
Step 1

Sequence of Roman numbers


#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
No. of rows 5 No. of rows
No. of columns 4 No. of columns
Start at 1 Start at

Sequence of increasing random integers Sequence of decre


#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME?
5
4
5000

Sequence of decreasing random integers


#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?
#NAME? #NAME? #NAME?

You might also like