Count columns until condition is met

[adams_adr]

Hello all,

Please help me find a function that will count the number of columns until I reach 100% or higher in each row of data.

The attached sample data illustrates the output I'd like to see in column B.

Thank you

Capture3.JPG

[davsth]

As an array formula (enter with shift control enter)
=IFERROR(MATCH(TRUE,(C2:N2>1),0),"not Found")

[bebo021999]

Try:

=IFERROR(AGGREGATE(15,6,COLUMN(C2:N2)/(C2:N2>=1),1)-COLUMN($B$1),"NOT FOUND")

[José Augusto]

Or a regular formula (base in @davsth)

Please Login or Register  to view this content.

[adams_adr]

As an array formula (enter with shift control enter)
=IFERROR(MATCH(TRUE,(C2:N2>1),0),"not Found")

Thank you davsth.

This worked a charm.

Much appreciated!

[adams_adr]

Thank you bebo021999.

This formula actually worked!!!

Thank you so much.

[José Augusto]

Hi

You don't ask that in the opening post. Your topic title doesn't say that.


=COUNTIF(C2:N2;">=1")

[Phuocam]

Delete the post.

[davsth]

Blue text is entirely down to the formatting of your own sheet. I just gave you a formula

[adams_adr]

Thank you very much.

It worked!