79829210

Date: 2025-11-25 00:26:33
Score: 0.5
Natty:
Report link
=LET(x_,COUNTA(A:A)-1,b1_,OFFSET(B1,,,x_),b2_,OFFSET(b1_,1,0),c1_,OFFSET(b1_,,1),c2_,OFFSET(c1_,1,0),d1_,OFFSET(b1_,,2),d2_,OFFSET(d1_,1,0),y_,IFERROR((d2_="IN")*(d1_="OUT")*(b2_=b1_)*(c2_-c1_),),y_)

enter image description here

sample file here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Has no white space (0.5):
  • High reputation (-1):
Posted by: JB-007