Forum Discussion
Stumped
How do you auto populate when it is not a fully numerical number? A-01-01 A-02-01 A-03-01 A-04-01 ...to A-38-01 Would appreciate any help.
Depends on which version of Excel you are. Variants
="A-" & TEXT(ROW()-ROW($B$2),"00")&"-"&TEXT(COLUMN()-COLUMN($B$2)+1,"00")
or
="B-"&TEXT(INT((SEQUENCE(38,5)-1)/5)+1,"00")&"-"&TEXT(MOD(SEQUENCE(38,5)-1,5)+1,"00")