Excel Help.....

[ddarko]

I'm next to useless on Excel (well I know when to hit the sum button !!!) & am looking for some help
regarding tracking the EC's.

Can anybody PM me the formula required to breakdown the 3 possibilities of the EC's ?

Eg A1 = 7 therefore B1 = RL/RO/OL ?

That kinda thing ?

As I test by hand, I'm just looking to quicken up that process......

Many many thxs to anybody who is willing to help me out 

[Nickmsi]

Hi . . .

Attached is how I breakdown the 3 EC's using Excel's formulas.

There are other ways to do this, but this is the one I always use.

If you need more help, just ask.

Cheers

Nick

[ddarko]

that's kinda it Nick, but not quite what I am looking for......

cell A1 number = 7

therefore

B1 = RL
C1= RO
D1=OL

So instead of what you just posted, at anytime (depending on what I'm looking to bet) I know what two of the Ec's are doing, so to speak, & said data is available in ONE cell only.

BUT, many thanks for what you did do, it's greatly appreciated 

[helena]

Maybe something like attached.

[ddarko]

Maybe something like attached.

Not quite Helena but thank you for your efforts 

I'm looking for the example below......

[helena]

OK, try this.

[ddarko]

OK, try this.

Bingo !!!!!! (I think, I need to check it some more) thank you v v v much Helena for taking the time to help me 

& the same goes to you Nickmsi 

[sniper]

Hello Nickmsi ,Helena and Ddarko

Since we are on this subject, I need help on Excel's formula regarding pattern recognition for baccarat.

I recorded my baccarat outcome vertically from top to bottom for each shoe. I need to locate 2 patterns among the data.

The first pattern is "BBPPBBP" and the second pattern is "PPBBPPB'. Once located the pattern should be high lighted.

Thank you very much.

Best wishes and regards

[Nickmsi]

Hi Sniper . . .

Yes, I have this pattern already coded but I am on vacation until 8/21/15.

If you do not get anyone else to do code this for you, just contact me directly at

nickmsi@aol.com.

Cheers

Nick

[sniper]

Hello Nickmsi,

Thank you very much. Enjoy your vacation.

Best wishes and regards to you and family.