79246181

Date: 2024-12-03 03:25:51
Score: 1
Natty:
Report link

I would use SCAN for anything that has the word "consecutive" in it:

Formula in F4 (can be filled down for the corresponding row):

=IF(OR(SCAN(0,G4:M4,LAMBDA(aggregated,current,(aggregated+current)*(current=1)))>=2),"OK","")

enter image description here

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