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
On this page of the site you can watch the video online Easy | Sequence Function in sheets | Basic Serial Numbering with a duration of hours minute second in good quality, which was uploaded by the user HitKit 17 September 2022, share the link with friends and acquaintances, this video has already been watched 27 times on youtube and it was liked by like viewers. Enjoy your viewing!
