Label X of Y

Occasional Visitor

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?

 

0 Replies