Finding 5 consecutive numbers in a set of 7 numbers

An Excel array formula to solve de problem if the data is in A1:A7 is

Formula:

=OR(AND(SMALL(A1:A7,1)+ROW(1:5)-1=SMALL(A1:A7,ROW(1:5))),AND(SMALL(A1:A7,2)+ROW(1:5)-1=SMALL(A1:A7,ROW(2:6))),AND(SMALL(A1:A7,3)+ROW(1:5)-1=SMALL(A1:A7,ROW(3:7))))

If data is in A1:G1 then the formula becomes

Formula:

=OR(AND(SMALL(A1:G1,1)+COLUMN(A:E)-1=SMALL(A1:G1,COLUMN(A:E))),AND(SMALL(A1:G1,2)+COLUMN(A:E)-1=SMALL(A1:G1,COLUMN(B:F))),AND(SMALL(A1:G1,3)+COLUMN(A:E)-1=SMALL(A1:G1,COLUMN(C:G))))

Don’t forget Ctrl + Shift + Enter

Best regards