Rampage123
02-24-2014, 02:48 AM
Hi all,
I am looking for a formula to pick up the non-zero minimum in an array.
The problem is the array is dynamic.
If you look at the attached sheet, I essentially need to find out non-zero minimum stock of an SKU for each depot.
I have put in both the input format in which I have data and the output format I need. Also, please note that I can't change the structure of the array. It has to be in the same tabular format.
Thanks for the help in advance.
I am looking for a formula to pick up the non-zero minimum in an array.
The problem is the array is dynamic.
If you look at the attached sheet, I essentially need to find out non-zero minimum stock of an SKU for each depot.
I have put in both the input format in which I have data and the output format I need. Also, please note that I can't change the structure of the array. It has to be in the same tabular format.
Thanks for the help in advance.