Let me give you some context: I am creating a packing note for a shoe manufacturer.
Here’s an example: Say we have four product batches, three of which are identical, one of which is different…
I’m using the ARRAYUNIQUE rollup formula to condense the three identical product batches into one, which is fine, but I also want to add up the total pairs by size of that unique batch, rather than, say, add up all the size 8s in the total shipment.
Here’s a screenshot… You can see i’ve managed to use ARRAYUNIQUE to only show the product reference and description once, but if I do the same with the size 8 column, for example, it’ll add them all up, won’t it i.e. 1 + 1 + 1 + 2 = 5, whereas I need it to be 3 + 2
I’m guessing I need a way of making the size 8 of one style unique to the size 8 of the other style??!