Excel question

[ricky100]

Does anyone now the formula for this situation:

I want to now at wish spin the first repeat comes. Lets say we have 10 spins and on the 11th we have a repeat number, the cell must give the value 11.....

Thanx...greetings

Richard

[winkel]

What information do you want:

a) the of the coups in which a "double" Number appeard (Position)

or

b) the gap betwenn the last und the new repeated Number. (difference)


Coups
1 Nr. 1
2 Nr. 6
3 Nr. 12
4 Nr. 1 (difference 3, Position 4)
5 Nr. 36
6 Nr. 30
7 Nr. 6 (difference 5, Position 7)

gruss
winkel

[ricky100]

Hello Winkel,

I want the sheet to do option B...in your example.

Richard

[winkel]

I will give you an Example of my map:

<pre>



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


</pre>


Row 1 the Coups
Row 2 = Field before minus field (to check if equal) for example: in B17 formula =A16-A17
Row 3 the Gap: from this number to their next appearance
formula in B3: =WENN(B3=0;VERGLEICH(B3;B4:B16485;0);"")

english formula names:
wenn = if
vergleich = ????
B4:B16485 = Range of Numbers (Permanenz)

this systems counts forward, not backwards. But i hope it will work for you.

gruss
winkel

[winkel]

please try this one:

Vergleich = match

[ricky100]

Thanxs Winkel..... :hear:

Will have a try with your formula too see if it does what i want it to do.

Greetings

Richard