79220393

Date: 2024-11-24 15:17:52
Score: 1.5
Natty:
Report link

For single row:

=MAX(SCAN(0, N(MAX(A1:N1)=A1:N1), LAMBDA(a,v, IF(v=0, a*0, a+v))))

For multiple rows:

=BYROW(
    A1:N10,
    LAMBDA(r, MAX(SCAN(0, N(MAX(r) = r), LAMBDA(a,v, IF(v = 0, a * 0, a + v)))))
)

enter image description here

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