Hi All
What is the formula I would need to use in the attached spreadsheet to calculated the lowest or first occurrence within a row?
As you can see in the top table Product A is delivered in weeks 2, 4 and 6, what I need is the lower table to show the first week i.e. wk 2 that the product has been delivered.
Is this possible?
Thanks in advance!
Bookmarks