Another question added to list:
I´m almost finished configuring my Excel sheet. I have some item that came twice, so there are two lines of each item with different quantities
For example: I have one pack with shoes size 39, 40, 41, 42, 43, 44 white and another pack the same item but in sizes 36, 37, 38, 39, 40 so they came in different lines. (I don´t mean a pack of products, but the boxes I receive, I sell them by unit)
So I expected that if I get one per size in different lines they add up, so in size 39 and 40 I would end with 2 x 39 and 2 x 40, but no:
I end up with:
1 x 39, 1 x 39, 1 x 40, 1 x 40 so this has no sense. There are too many lines in my list, up to 1200 lines. I cannot look for duplicates and add up by hand.