Help with an excel tracker

[Kattila]

Hi , i need help to improve this tracker.
Tracks 4 systems , 6 numbers based  each , but i need to track
also the positions between same group of numbers , so  until
8 positions if possible and for each system.

EX:

[reveal]










Group    pos

4
3
1
4            3
4            1 and 4
2
2            1
6
2            2 and 3
4            5 and 6
1            8
6            4
1            2
2            5 , 7 and 8
1            2 and 4
1            1  and 3
4            7
5
3
3            1
1            5 and 6
5            4
3            3 and 4
6
2
5            4
5            1 and 5
2            3
1            8
4
6            7
1            3
1            1 and 4
5            7
4            5
5            2

[/reveal]

[Azim]

you have s1 and s2 and s3 and s4   add the lines under there to what you want for as far as you want to go...

After go to the column s1 and change this in the formula...


=IF($A5="","",VLOOKUP($A5,Sheet2!$A$1:$E$38,2,0))
blue -> chnage it to the start of the column.
red ->change it to the last row and column.

Not sure if i understood your help..

[Kattila]

Thanks Azim that you try to help me, but  i have no idea how to do it.
Basically i need one column  right side of each system , which track/show the positions
between same group (see example in reveal ).

[Azim]

I hope this is right.

[Kattila]

Do not work for now.

[Bigbroben]

Hi Kattila,

Here is something for you.

I wasn't sure if you liked the position to be stopped at the 6 groups or according to the amount of spins since la st hit on group.

Anyway,  here is a quick tracker of what I believe you requested.  Rough, no fancy display but hey!

[Kattila]

Hi  Bigbroben,
Please look again at the first post /reveal , it s about the position/distance between the same
group.

Example:

4234  .....here pos  3 ( from 4.....to  4)
55......here pos 1 ( from 5 to 5 )
626.....here  pos 2 ( from 6 to 6 )
25462.....here pos 4 ( from 2  to 2 )
341613....here pos 5 ( from 3 to 3 )
but also  pos 2 (from 1 to 1 ).

234262....here pos 3 ( from 2 to 2) but
also pos 5 ( from first 2 to last 2)
so hit pos 3 and  pos 5

[Bigbroben]

Hi Kattila,

try this one then.  Should be good.  It only tracks the position since last hit.

[Kattila]

Hi BBB,
Only S1 works fine , the other 3 not, but no worries, i know it's not easy work.
Thanks anyway .   

[Bigbroben]

Hi,

Yeah, little mistake.  Corrected in this version;

[Kattila]

Many thanks  B.       

[ketan10@btinternet.com]

Hello - May I ask how we play this system, please?
Thanks.