79106358

Date: 2024-10-20 04:26:06
Score: 0.5
Natty:
Report link

You can also write SCAN() like below to count consecutive non-blank cells:

=SCAN(0,H4:O4,LAMBDA(aggregated,current, (aggregated+1)*(current<>"")))

To find the largest consecutive count, you can also use SORT() and TAKE():

=TAKE(SORT(VSTACK(H3:O3, SCAN(0, H4:O4, LAMBDA(aggregated, current, (aggregated + 1) * (current <> "")))), 2, -1, TRUE), 1, 1)

enter image description here

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
Posted by: rachel