Hello,
I have a sheet which I'll be using as a stock and inventory report. The sheet "Lagersaldo" need your help. I will add to this regularly, via "Lastat". I would like a code to combine rows in "LAGERSALDO" if they have D, E and L in common, and at the same time sum value of F. I have tried with multiple codes but i can't seem to tweak them to my needs. I've placed and IF formula with a nested RAND in L to keep pallet "not full pallets" separated and not merging. I've attached the file, please tell me if you can help or need more information. And please, I don't want to use a pivot table.
Best regards,
Joel
Bookmarks