Finding 5 consecutive numbers in a set of 7 numbers

Hi Evolta

The proposed issue is "Finding 5 consecutive numbers in a set of seven numbers."
I considered Ace = 1 or 14 Jack = 11; Queen = 12; King = 13.

To simplify the formula I set the Seq name as
=MATCH($A$1:$A$7,ROW(A1:A14)+IF(ROW(A1: A14)>7,3,0),0)

Formula:

=MATCH($A$1:$A$7,ROW(A1:A14)+IF(ROW(A1: A14)>7,3,0),0)

Thus the desired formula is
=OR(IFERROR(AND(MATCH(SMALL(Seq,1)+ROW(1:5)-1,Seq,0)>0),FALSE),
IFERROR(AND(MATCH(SMALL(Seq,2)+ROW(1:5)-1,Seq,0)>0),FALSE),
IFERROR(AND(MATCH(SMALL(Seq,3)+ROW(1:5)-1,Seq,0)>0),FALSE),
AND(MATCH(ROW(1:5)+IF(ROW(1:5)=1,13,0),A1:A7,0)))

Formula:

=OR(IFERROR(AND(MATCH(SMALL(Seq,1)+ROW(1:5)-1,Seq,0)>0),FALSE),IFERROR(AND(MATCH(SMALL(Seq,2)+ROW(1:5)-1,Seq,0)>0),FALSE),IFERROR(AND(MATCH(SMALL(Seq,3)+ROW(1:5)-1,Seq,0)>0),FALSE),AND(MATCH(ROW(1:5)+IF(ROW(1:5)=1,13,0),A1:A7,0)))

Best regards