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.
4 Replies
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")In this case you can combine ROW and COLUMN functions to convert its placement to a number while using CONCATENATE to tie them together. I added a letter next to the corresponding table to make the lookup more dynamic, you can hide it by converting the font to White.
Appreciate the help, I'll look into this after the holiday.
Thanks again!
