[12/10, 1:50 pm] Yetki: =AND(A3<>"",

OFFSET(A3, 1, -1)<>"",

IF(A3 < OFFSET(A3, 1, -1),

ABS((A3 + 1 - OFFSET(A3, 1, -1)) * 24) < 12,

ABS((A3 - OFFSET(A3, 1, -1)) * 24) < 12)

)

[12/10, 2:28 pm] Yetki: IT WORKS 10 IN ROW

=AND(COUNTA(OFFSET(A1, 0, -10, 1, 10)) = 10, COUNTIFS(OFFSET(A1, 0, -10, 1, 10), ">=0", OFFSET(A1, 0, -10, 1, 10), "<=1") = 10)