finding the first value (non-zero) in a row

[daveyc18]

So, let's say I have data from rows B to F

im trying to find the first value (non-zero) in the row...and then when it does...use the minimum formula from the column with the first value (non-zero) to column F

thanks!

 

[theBardd]

=min(if(b2:f2<>0,b2:f2))

array-entered