excel again :)

[holy roller]

Ben can you help me out with this Excel question? I enter the spin results in the one column. then those numbers produce the numbers that show up in the numbers to bet column.

What I want to accomplish is to take the 3 columns that have the Numbers to Bet and put them all into one column. Then I want to sort it numerically from smallest to largest number. I also want it to delete any duplicate numbers. So if the #1 shows up three times I only need to see it once. (See attachment)

Hopefully that makes sense. Thanks for your help Ben!

[Bigbroben]

Hi Roller,

I've setup a new sheet where you can have all the nrs from the three column put in a increasing order.  It is not in one column but at least in one block.

This is the way I do it normally.  There are other parameters that can be added, such as max played mrs, W/L, reset conditions, progs....

Have a look.

[holy roller]

That is excellent Ben! I think I would like to be able to add W/L and Reset on a Win to the spreadsheet as well. That would be very helpful. Thanks for your help with this spreadsheet Ben.

[Bigbroben]

Ok, try this one.

You can choose to reset on a hit, at new high or not at all.

[holy roller]

Thanks for your help Ben. I hope to be able to put that to good use now. Thanks again for everything you do for this group.

[holy roller]

Does anyone know if this example below is possible to do in Excel?

I want to have a numbers that were spun column, and with each number that is spun it will be associated with 4 other numbers. Those 4 numbers will always be the same numbers.

Then i want Excel to search those 4 numbers and see if they correspond with any of the numbers that have already been spun as seen in the example below when numbers 3 and 26 are spun.

nrs       numbers to bet
1           1-10-22-34
2           2-16-25-29
3           3-18-19-26
4           4-6-30-31
5           3-5-27-28
6           0-6-11-32
26         3-18-19-26


So when there is a match with numbers spun like 3 and 26 because they both have the same 4 numbers Excel would tell you to bet numbers 3-18-19-26.

I am just curious if that is possible to do or not. Thanks for your help everyone.

[lesliewheeler]

Well,

just take this one instead, it's "enhanced".

Hi Bigbroben

There is some error in excel in showing  number to be played

For the series of live results 8,34,29,7,32,27,31,34,24,5

Play trigger number are showing as 12number to be played however it shows only 8 number 3,6,13,16,23,26,33,36

Next spin was 30 and it showed result was a WIN.

Pls can you check..

[Nickmsi]

Hi Holy Roller,

See if this attached sheet does what you want.

Simply insert your data sets into Column G.

Insert the numbers spun into Column A or use the F9 for RNG numbers.

Column E will show a repeat with the number "2" else no repeat is "1"

Cheers

Nick

[holy roller]

Well shoot Nick. I didn't know it was as simple as a VLOOKUP command. I thought it was a MATCH or CHOOSE, which I have never done before. The matching with the 1 and 2 is very clever. Thank you for your help. That should work Nick.

[lesliewheeler]

Hi Bigbroben

There is some error in excel in showing  number to be played

For the series of live results 8,34,29,7,32,27,31,34,24,5

Play trigger number are showing as 12number to be played however it shows only 8 number 3,6,13,16,23,26,33,36

Next spin was 30 and it showed result was a WIN.

Pls can you check..

Never mind have fixed it myself

Thanks

[Bigbroben]

Very well!  Glad you tried.  I've learnt from scratch.  Anyone can do it too!

[Gitano]

Hi All!

can someone help me in column P to avoid that number 1's shown without numbers spun ?

I've used in P:     =IF(OR(O3=$B$3;O3=$C$3;O3=$D$3;O3=$E$3;O3=$F$3;O3=$G$3;O3=$H$3;O3=$I$3;O3=$J$3;O3=$K$3);1;"  ")


And for column  X Y,Z,AA shown only the maximum distance between sorting lists (0's) .Just for example 7-->3  without  6 5 4 3 2 1 as shown in picture..

This is an idea I had for a system I want to test..

Thanks

Gitano

[Gitano]

This is the file,
basically my idea was to see how many times a certain distance in terms of spins ( for example 7 ) happen that the ball land in less spins again..
I don't know why but It seems to be a lot of time.. With this file I would check this behavior in the airball considered.

[ati]

can someone help me in column P to avoid that number 1's shown without numbers spun ?

You simply have to add one more condition to the formula. If the "numbers" cell is not empty, do the calculations, otherwise return a blank value.

=IF(O26<>"",IF(OR(O26=$B$3,O26=$C$3,O26=$D$3,O26=$E$3,O26=$F$3,O26=$G$3,O26=$H$3,O26=$I$3,O26=$J$3,O26=$K$3),1," "),"")

[ati]

By the way, there is a simple way to check if a cell value equals any other in a range of cells. No need to type in each condition one by one.

It looks like this:

=IF(O26<>"",IF(COUNTIF($B$3:$K$3,O26),1,""),"")

The other question I don't understand. Sorry.
There also seem to be an error in columns U and V. The ISBLANK formula is missing the reference.