Forum Discussion

rshenk3's avatar
rshenk3
Copper Contributor
Oct 05, 2023
Solved

Automatic Carton Numbering

Hello and thank you,   So here's the deal.  I have a spreadsheet with the entire selection of possible products ordered from us by a customer.  I would like to be able to receive a PO from the cust...
excel
Formulas and Functions
office 365
  • Patrick2788's avatar
    Patrick2788
    Oct 07, 2023

    rshenk3 
    Like this?

     

    If that's the case, then we change the initial value in SCAN from 1 to 0:

     

    =LET(
    carton_numbering, LAMBDA(a, v,
        IF(
            v = "",
            TEXTAFTER(a, ",", -1, , , a),
            TEXTJOIN(",", , SEQUENCE(v, , a + 1))
        )
    ),
    SCAN(0, boxes, carton_numbering)
)

     

     

rshenk3's avatar
rshenk3
Copper Contributor
Oct 05, 2023
I'm sorry but this doesn't seem to solve the issue. In your solution you say to copy a formula in cell H3 and drag down the rest of the column. In the next step you say to copy a formula into cell H4 and drag down the rest of the column. There is no way to ensure the values in column J are unique as they are box counts, and if I'm not mistaken you have said nothing about what to put in column V. I'm sorry but this really doesn't help at all.
peiyezhu's avatar
peiyezhu
Bronze Contributor
Oct 05, 2023

Can you show your expected result according to the sheet Master?

Which columns are source and which are expected result?

Resources