Easy | Sequence Function in sheets | Basic Serial Numbering
Automatically fill serial number in Colums using the
#excel #google #sheets #exceltips #googlesheets #googlesheetstutorial
=SEQUENCE(rows, columns, start, step)
Example
Example 1: SEQUENCE(2)
Example 2: SEQUENCE(2, 3)
Example 3: SEQUENCE(2, 3, 3, 2)
Example 4: SEQUENCE(2, 3, 10, -1)
Notes
If columns is omitted, the resulting array will be a vertical list. If a horizontal list is needed, either specify rows as 1 and specify columns or transpose the vertical result.
Result for A1=SEQUENCE(2)
A B
1 1
2 2
Result for A1= SEQUENCE(2, 3)
A B C
1 1 2 3
2 4 5 6
3
Result for A1= SEQUENCE(2, 3, 3, 2)
A B C
1 3 5 7
2 9 11 13
3
Result for A1= SEQUENCE(2, 3, 10, -1)
A B C
1 10 9 8
2 7 6 5
3 4 3 2
Please subscribe if this was helpful