I don't know if this question has been answered before, but searching don't find any result that matches my needs.
I 'm looking to find a way for programming excel for finding a sequence (or a pattern) of number 0-36 from Roulette wheel.

Say we got output like this:
1,2,5,6,4,1,2,5,9,6,4,1,4,5,8,1,2,6,4,7,8,5,4,1,3,7,9 This data will be saved for databank. This databank will be used for 10.000 data.

I wanted to look what number appears after number 1 : answer=2,2,4,2,3
I wanted to look what number appears after sequence of 1,2 : answer= 5,5,6
I wanted to look what number appears after sequence of 1,2,5 : answer=6,9

How can I program excel to store such a databank, and then look for sequence of 1,2,3 number patterns?