I want to count the number of columns containing entries in them per row.
I used the formula :
=ArrayFormula(countif($H$4:$4,"<"&$A$4:$A)/count($H$4:$4))
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI want to count the number of columns containing entries in them per row.
I used the formula :
=ArrayFormula(countif($H$4:$4,"<"&$A$4:$A)/count($H$4:$4))
this might work...
=ARRAYFORMULA(IF(A4:A="",,MMULT(N(OFFSET(H4,,,ROWS(H4:H),COLUMNS(H4:4))<>""),SEQUENCE(COLUMNS(H4:4),1,1,0))))