Counting Dozens

[holy roller]

Hello all,

I need to see if someone has an Excel formula that will allow me to count 24 numbers at a time. I want to be able to tell when a group of 12 numbers has not shown up.

I am just saying dozens to keep it easy, but I am not going to track the traditional 1-12, 13-24 and 25-36. For simplicity I will use those as the reference though.

So if the first dozen hasn't shown up for 4 spins I want something like 1D to be displayed in the spreadsheet. It shoudl be a really simple spreadsheet with the spin numbers in column A. Then it is blank in column B until the dozen that hasn't shown up in the last 4 spins shows up like... 1D.

Thanks all.

[Patrick999]

Hey there,
Don't have it - just a word of warning... I recently blew a BR doing dousins... waited for a dousin to not show up 9 times..... Went for it - it did not show up another 31 times!?!?!? Freaky.... but OUCH! 40 misses is possible.

[Normy2000]

Hello all,
I need to see if someone has an Excel formula that will allow me to count 24 numbers at a time. I want to be able to tell when a group of 12 numbers has not shown up.

See my 20 Groups Tracker/Clicker at norcosoft dot com. You can track 20 groups of 12 numbers at a time.
Regards, Normy