79136303

Date: 2024-10-29 08:15:51
Score: 2
Natty:
Report link

You could use BYROW and SCAN:

=BYROW(SCAN(0,A1:D4,LAMBDA(a,b,IF(b>50,a+1,a*0))),LAMBDA(y,MAX(y)))

ByrowScan

Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Excellor