Findest the lowest occurence in a row

**mrchoppychops** · 05-07-2009, 10:57 AM

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!

**windknife** · 05-07-2009, 11:27 AM

B7
=IF(COLUMN()=MIN(IF(ISNUMBER($B2:$I2),COLUMN($B2:$I12))),"x","")

Commit with Ctrl+Shift+Enter, drag down this formula to fit your range

Sample file is as attached

HTH,

windknife