May 11 2021 11:33 AM
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.
May 11 2021 01:26 PM
As variant
with custom number format instead of IF()
Formula is
=--ISNUMBER(SEARCH("111",TEXTJOIN("",0,--(A1:F1>15))))
May 11 2021 01:27 PM
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),
IFERROR(IF(MAX(seq)>2,"√",""),"√"))
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ᵣ
so
= LET(
selected, SIGN(values>16),
seq, ACCUMULATE(selected, 0, selected-1),
IF(MAX(seq)>2,"√",""))
also works for me.