Hello,
There is a warehouse with products. Every product consists of boxes with different weight. Every time a box from a warehouse goes to the shop it should be highlighted. So if the same weight from the warehouse is entered in the shop area, they both should be highlighted. But sometimes there are boxes with same weights (like C7 and C11). When one of these boxes goes to the shop, then only one should be highlighted in the warehouse. Also there could be mistakes in the shop area with no such weights in the warehouse (like G7 and A15). In such case, box in the shop area should not be highlighted and I would know that there is a mistype.
Picture:
Could you please help me with the right formula to resolve my problem?
There is a warehouse with products. Every product consists of boxes with different weight. Every time a box from a warehouse goes to the shop it should be highlighted. So if the same weight from the warehouse is entered in the shop area, they both should be highlighted. But sometimes there are boxes with same weights (like C7 and C11). When one of these boxes goes to the shop, then only one should be highlighted in the warehouse. Also there could be mistakes in the shop area with no such weights in the warehouse (like G7 and A15). In such case, box in the shop area should not be highlighted and I would know that there is a mistype.
Picture:
Could you please help me with the right formula to resolve my problem?