test the continuity of the cells



3 Replies


Here is a solution with some helper columns.

In G1: =COUNTIF(A1:C1,">15")=3

Fill to the right to J1, then down to G3:J3.

In K3: =IF(OR(G1:J1),"√","")

Fill down to K3.

You can hide columns G to J if you wish.




As variant


with custom number format instead of IF()

Formula is



This is a 365 solution.  I think it will port to traditional methods but I only use 365.

= LET(
   k, SEQUENCE(1,6),
   selected, FILTER(k, values>16),
   bins, FILTER(k, values<=16),
   seq, FREQUENCY(selected, bins),

 This formula counts the selected values that lie within each bin defined by the non-selected values.

I also have the advantage of a copy of FastExcel so I can use an ACCUMULATE function that evaluates the recursion equation

Uᵣ₊₁ = aᵣ+(1+bᵣ)Uᵣ


= LET(
   selected, SIGN(values>16),
   seq, ACCUMULATE(selected, 0, selected-1),

also works for me.