Results 1 to 7 of 7

Thread: Finding non-zero minimum in a dynamic array

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Finding non-zero minimum in a dynamic array

    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •