excel again :)

[Stepkevh]

hi everyone,

my last post was of great help and i was able to make my own excel with betting and profits. for an excel novice 

now i'm trying to make another sheet that follows the last 2 doz/cols but i cant make it work 
if i have something like this what do i need as formula if smby knows

1
1
1
   2 
       3
       3
1
       3
   2

[mattymattz]

pretty simple:

Have Column A be your spins
Have Column B,C,D track your dozens (respectively)

use a vlookup to simplify it.

I'll attach a spreadsheet in 5 mins.

MM

[mattymattz]

hope this is similiar to what you wanted.

MM

[signurinu]

This is for dozens and columns also. Have fun!

[TwoCatSam]

Perfect!  (Well, for me anyway.)

Thanks, MM.

Sam

[Stepkevh]

hope this is similiar to what you wanted.

MM

this is what i can get done also
i want excel to show me 2 last dozens to bet

1
1
    2
       3
1
so excel should show me

x  x
    x  x
x      x

if the dozens fall right after eachother theres no problem but when for ex doz3 falls 7x en then d1 3x.
what do i need as formula then, thats what i cant get to find out.

[mattymattz]

this is what i can get done also
i want excel to show me 2 last dozens to bet

1
1
    2
       3
1
so excel should show me

x  x
    x  x
x      x

if the dozens fall right after eachother theres no problem but when for ex doz3 falls 7x en then d1 3x.
what do i need as formula then, that's what i can't get to find out.

Sorry Step - you've got me confused now.  If you want it to show last 2 dozens, my sheet does that as well... so not sure what you wanted.

MM

[TwoCatSam]

this is what i can get done also
i want excel to show me 2 last dozens to bet

1
1
    2
       3
1
so excel should show me

x  x
    x  x
x      x

if the dozens fall right after eachother theres no problem but when for ex doz3 falls 7x en then d1 3x.
what do i need as formula then, that's what i can't get to find out.

You have five numbers: 1,1,2,3,1.  Are these dozens or spins produced by the wheel?

Your x chart has six xs.

If we knew what system you were playing, it might help.  Or how you're wanting to bet.

Sam

[Stepkevh]

i just want to follow the last 2 dozens/columns

my chart represents the dozens, because the 1 was 2x behind eachother it doesnt count for an "x"

so what you see there is
1 2
x x
   2  3
   x  x
1
x     x

understand it somewhat

[TwoCatSam]

So you want the dozens in rows not columns?  Horizontal?

[Stepkevh]

i want excel to show me the last 2!! (not 1 doz) dozens always on the horizontal line.

[Stepkevh]

it should give the outcome like viktors saliu tracker

doz 1/2   1/3  or   2/3

[TwoCatSam]

Pardon me!

[mattymattz]

Steph,

see new attached sheet - is this what you wanted?

MM

[Stepkevh]

Pardon me!

Sorry sam.
Didnt meant it bad !! :-D