detect uninterrupted sequences of 2,3,4,5,6,7,8,9 ... numbers.

detect uninterrupted sequences of 2,3,4,5,6,7,8,9 ... numbers. objective is to identify sequences of 2,3,4,5,6,7,8,9. without interruption between the numbers in the two sectors
ex 01 02 06 07 09 .....
01 06 11 16 15 20 25 .... etc
https://www.excelforum.com/attachmen...1&d=1609703576

in the indicated place the formula is not working

hello,aligw , cell p6

hello rorya, thanks for viewing the post ok come on =
look at the matrix of that lottery
01 02 03 04 05
06 07 08 09 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25
this is the lottery matrix being treated,
in blue is the vertical sequence, ok
look in the 1st vertical position é = 01 06 11 16 21
in yellow it is the horizontal sequence and in blue it is in the vertical carteziano type, 15 numbers are drawn in
25 of the matrix, I need the sequences of 2,3,4,5,6,7,8,9 ... horizontally (yellow) and vertically in blue, to later assemble the carteziano

but in the blue sector the macro will see in the draw the uninterrupted sequence as in the yellow and mark
with x or other shape, it can be colors

@jorel,

If you see that others do not understand your "oral/verbal explanation in writing", include an adequate example in the 'xls' file and maybe additionally graphic in the image.
This what you showed in the file does not "carry" any specific information about how the macro should act on this data.
In the 'zip' file there is an image of what I tried to understand (like others) from your description.
Question marks mean what I (and others ?) don't understand, e.g.:
Where will the numbers to be searched ?
Where will the search numbers be marked ?
Where to look for them ?
Etc.

hello PORUCHA, thanks for viewing the post, well we have the horizontal strings from 01 to 25
and the vertical sequences, that is, two sectors, the macro or formula, will detect uninterrupted sequences of 2,3,4,5,6,7,8,9 numbers in a row,
objective is to find horizontal and vertical sequences

I MILIZ ,believe that it is missing, something only with this formula does not search. See if you can get the complete formula

... one more time ...

Should it look like the image below ?

1. We enter some numbers in the yellow field and the macro should search for this string in rows in the range of cells "$A$6:$O$2101" ?

2. We enter some numbers in the blue field and the macro should search for this string in columns in the range of cells "$A$6:$O$2101" ?

yes, PORUCHA, it is correct, but in the blue sector, and not in the list of draws to look for from the uninterrupted strings, it must be in both sectors

hello, PORUCHA . OK,question 1, and 2, your thinking is correct, you can do it as explained in the image, ok, yes for 1 and 2

hello, porucha ex=
https://www.excelforum.com/attachmen...1&d=1610389254