Hi Everybody
I got trouble making conditional Min formula and couldn’t come up with any solution.Could you kindly help advise on below case. Thank you very much !!
At the column Min, find the smallest number for the column Qty Available for the item at FSC column.
(if it’s F1653111- smallest number is 699). I use MINA function but problem is I have to go to every item (F1653111,F1655111,F2081034, ect….) to copy and paste the formula and that takes a lot of time.
Could you help set up a conditional MIN formula that will automatically find the smallest number at the Qty avail column when the item changes? (for ex from 1655111 to 2081034 ect...)
Thanks a lot in advance !!
Bookmarks