Share via

pls what is th formula for this sequanse for excel product serial number

Anonymous
2025-05-14T06:05:32+00:00

Gm12001-01

Gm12001-02

Gm12001-03

Gm12001-04

Gm12001-05

Gm12002-01

Gm12002-02

Gm12002-03

Gm12002-04

Gm12002-05

Gm12003-01

Gm12003-02

Gm12003-03

Gm12003-04

Gm12003-05

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-05-15T09:01:10+00:00

    An alternative formula. Apply it in cell C2.

    ="Gm1200"&TEXTSPLIT(TEXTJOIN("",,REPT(SEQUENCE(3)&",",5)),,",",TRUE)&"-"&"0"&TEXTSPLIT(REPT("1,2,3,4,5,", 3),,",",TRUE)

    HTH

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-05-15T13:46:38+00:00

    Another:

    =LET(c,20,"Gm " &INT(SEQUENCE(c,,12001,1/5)) & "-0" & MOD(SEQUENCE(c,,0),5)+1)

    change the 20 to however many serial numbers you need to generate.

    0 comments
  3. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2025-05-14T23:48:15+00:00

    Hi,

    In cell C2, enter this formula

    ="Gm "&TOCOL(12000+(SEQUENCE(3)*SEQUENCE(3,5,1,0)))&"-"&TOCOL("0"&SEQUENCE(5)*SEQUENCE(5,3,1,0),,TRUE)

    Hope this helps.

    0 comments
  4. Anonymous
    2025-05-14T08:14:13+00:00

    Hi there

    Please, try the formula

    ="Gm "&INT((ROWS($A$1:A1)-1)/5)+12001&TEXT(MOD(ROWS($A$1:A1)-1,5)+1,"-00")

    I hope this answers your question.

    Kind regards

    Jeovany

    0 comments