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)

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)))

Best regards

## Bookmarks