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]
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..
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 ).
I hope this is right.
Do not work for now.
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!
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
Hi Kattila,
try this one then. Should be good. It only tracks the position since last hit.
Hi BBB,
Only S1 works fine , the other 3 not, but no worries, i know it's not easy work.
Thanks anyway .
Hi,
Yeah, little mistake. Corrected in this version;
Many thanks B. :thumbsup:
Hello - May I ask how we play this system, please?
Thanks.