How many cells are 0 till first cell is >1

[OnestopwarehouseEurope]

 

[Fluff]

Hi & welcome to MrExcel.

How about

=IFERROR(MIN(FILTER(SEQUENCE(,12),M2:X2>0)),1)

Also in future please write your post using normal text, rather than posting an image with massive text.

 

[Peter_SSs]

count of content "0" from left to right (M:X) + 1

So if ..
the first row should be 4 because there are 3 zeros before the first non-zero value (3+1) and
the third row should be 1 because there are 0 zeros before the first non-zero value (0+1)
.. then I don't understand why the second row should be 12 since that should mean there are 11 zeros before the first non-zero value (11+1) but that is not the case since there is already 12 zeros in the row.

However, if 12 really is the value you want in that situation you could try

=IFNA(XMATCH(TRUE,M2:X2>0),12)

or if the number of columns might change a more general version would be

=IFNA(XMATCH(TRUE,M2:X2>0),COLUMNS(M2:X2))

 

[OnestopwarehouseEurope]

@Fluff, yes I will.

thanks for reply, working

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Peter_SSs]

.. working

Since 3 suggestions have been made, I'm wondering what is working?

 

[Joe4]

Since 3 suggestions have been made, I'm wondering what is working?

It appears to me that their reply was directed to Fluff:

@Fluff, yes I will.

thanks for reply, working

 

[Peter_SSs]

It appears to me that their reply was directed to Fluff:

Yes, I thought that too, but since @Fluff's formula does not produce the expected result for one of the sample data rows I was pressing the point.

 

[OnestopwarehouseEurope]

someone was to optimistic in his reaction.....
colleague responded without any check, unfortunately I am still without a working formula

 

[OnestopwarehouseEurope]

so after few attempts it worked: =IFERROR(MATCH(TRUE;INDEX(M2:X2>0;0);0);"NO")