March 13, 2021
Hi so I am using Excel on PC and I have to distribute a certain number of inventory (cell T2) into orders at different locations (cell A2:R2). However, I have to make sure that the inventory is greater or equal to target inventory (cells A13:R13).
However, the final distribution can not exceed the order number (which is the maximum limit) even if the target inventory is higher than order.
Can anyone help me crack this w any formula?
So the point that I am trying to achieve is that if there is insufficient inventory, even then all the customers get some of it. There is no priority, just want to distribute a number to each higher than the target and lower than what they have ordered
(if target is higher than order, then automatically the order becomes the top limit)
order number-top limit
target number-bottom limit
September 9, 2020
Hi Arte Mis,
For me, the file is not enough to understand exactly what the problem is. There is data but we don't know where it comes from or if it is attempts or not. Can you add examples with the desired result and comments to make sure we understand the process to be established? Thank you,