CODEWITHSUNDEEP
arraysif-statementgoogle-sheetsgoogle-sheets-formulaarray-formulas
Nabin Regmi
Nabin Regmi

Reputation: 1

Auto serial number in column

I am try generate auto serial no. starting from 500 (like ABC 500, ABC 501 and so on) by using Array Formula in my google sheets.

Is there any solution ??

Upvotes: 0

Views: 240

Answers (2)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA("ABC"&ROW(A500:A1000))

or bind it to just valid non-empty rows:

=ARRAYFORMULA(IF(B2:B<>"";;"ABC"&ROW(A500:A1000)))

Upvotes: 1

a-burge
a-burge

Reputation: 1574

=ARRAYFORMULA("ABC "&SEQUENCE(3,1,500,1)) will do the trick. Read up on the specifics of the functions in the documentation.

Upvotes: 1

Related Questions