Excel Tracker HELP

[Kattila]

Hi , i need help with my tracker.
Tracks right now dozens, columns, double streets, streets, splits.
What i need if possible track for each from above the positions between same group
of numbers ( for ex.  2132  is pos 3  between group 2,  other 62346 is pos 4 between gr 6)

For doz and col  it s ok positions 1,2,3,4
For  DS   ....1,2,3,4,5,6
For streets ......1,2,3,4,5,6,7,8,9
For splits..........1,2,3,4,5,6,7,8,9,10,11,12


Example double streets

DS   Position

3
6
1
5
6        3
6        1, 4
1        4
2
1        2, 6
3
3        1
1        3,5

[Bigbroben]

Only last gap between same group or you want also the previous gap(s)?

[Kattila]

 Yes  also the previous gap(s) , Thanks BBB

[Bigbroben]

Here!

Did not add previous gaps yet, but this is a start...

P.S.: I normally change ''0'' for ''37'', since 0 is a common part of Ecxel conditions .

Will work on previous gaps as soon as I find time.

[Bigbroben]

Kattila,

I hope you'll be able to use the tracker.  When working on your file, I think your Excel version did not allow more than 9 or 10 conditions in one formula, mine allows much more, so I transferred.  Hope it is compatible!

[Kattila]

You right , doesn t work for me , old version.  I need supose last version of Excel ?
Can be sent by email and instal(rar file) in my laptop ? Or buy from internet ?

[Bigbroben]

I think I'll just modify the formula in  cells and see if it's ok.

Later!

[Kattila]

Ok , thanks
I tried also  with ofice 2016 but still don t work. Can not track the positions /gaps.

[Bigbroben]

How many previous gaps do you want?

[Kattila]

With  3 i have enough ....

[Bigbroben]

Sure?

It's 10000$ per gap...

[Kattila]

You will be rich then, now i go to the bank....want via paypal, bank transfer....

[Bigbroben]

He's what we'll do:

put the 10k on red.
Split 50-50 if win.

[Bigbroben]

Working on Kattila's first, between family tasks, then you're next.

PM or here for description.

[Bigbroben]

Here Kattila,

you better enjoy this, câliss, it was time consuming!

All infos brought clear and clean in Sheet1.  Doz, column, DS, Street, Splits, their actual gaps on the hit and the 2 previous ones.

Should work with your Excel version, I used the same file.  Had to Zip it, was too large, 9mb.  Hope you have a zip program.

If you will,  send a PM giving me a hint on how you plan to use this info in the file!

P.S.  Use nr.37 instead of 0 when entering nrs in sheet1 column b