roulette analysis

19
0
27
26
0
13
11
31
1
28
1
30
15
13
5
18
26
14
2
24
17
22
23
17
14
32
7
28
13
27
26
7
13
32
4
25
35
28
19
3
10
26
23
12
8
18
5
6
12
19
1
30
5
5
2
10
18
21
4
23
22
3
10
1
5
15
9
21
17
31
18
34
25
33
10
36
4
5
8
5
25
3
28
7
10
11
7
22
16
17
3
35
19
10
19
18
7
7
11
26
6
6
23
11
5
3
29
8
1
33
14
11
9
15
32
21
16
3
20
4
21
34
8
9
17
5
26
5
26
35
23
10
23
3
31
35
7
29
36
3
16

These are around 100 plus spins

pasted at cell a1 downwards

on c1 I have say query example 19

I want results on e1 downwards as to what number came after 19

expected answer for 19 is

0
3
1
10
18

I am looking for what numbers got played after say a certain number

Give this a try in E1. Copy downwards.

Please Login or Register  to view this content.

Hope it works for you

Works only for the result for 19 spin for the first time , how about the spin of 19 occurring for the second time

Here is file

TRY

=INDEX($A$1:$A$150,SMALL(IF($A$1:$A$150=$C$1,ROW($A$1:$A$150)-ROW($A$1)+2,""),ROWS($A$1:A1)))

Enter with Ctrl+Shift+Enter

Thank you Tony and John