Sep 21 2022 12:11 AM
Hello there,
I am struggling from some time now to create a formula in excel and also in gsheets... for a major problem:
we have orders from a online marketplace
in one order define by ORDER ID... we can have maybe one product... sometimes multiple products...
this is how export orders look like
https://imgur.com/Bz1mByP
i need to create count labels for each order... based on qty and also no of products... 1 of 5, 2 of 5, 3 of 5... so on... to verify all the products for entire order...
those count labels are based on total qty and total no of products.... in one order...
is a similar thing for AWB delivery/expedition for courier.... multiple destination, multiple/different numbers of boxes for each destinations...
can u help us with a formula or a way to create those labels?