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
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
As an array formula (enter with shift control enter)
=IFERROR(MATCH(TRUE,(C2:N2>1),0),"not Found")
Try:
=IFERROR(AGGREGATE(15,6,COLUMN(C2:N2)/(C2:N2>=1),1)-COLUMN($B$1),"NOT FOUND")
Quang PT
Or a regular formula (base in @davsth)
Formula:Please Login or Register to view this content.
Thank you bebo021999.
This formula actually worked!!!
Thank you so much.
Last edited by adams_adr; 10-06-2020 at 08:18 AM. Reason: Missing information
Hi
You don't ask that in the opening post. Your topic title doesn't say that.
=COUNTIF(C2:N2;">=1")
Delete the post.
Last edited by Phuocam; 10-06-2020 at 08:24 AM.
Blue text is entirely down to the formatting of your own sheet. I just gave you a formula
Thank you very much.
It worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks