Request for help for producing some Excel code (macro)

Can anybody assist in producing an Excel macro for me, please?

I have a spreadsheet were Baccarat results are recorded in columns of four (running top to bottom, left to right);

[decisions]
1-5-9
2-6-10
3-7-11
4-8-12 etc

this presents 16 possible combinations for any 4 hand sequence. What I would like to do is enter any 4 hand sequence and for a macro to present a count for the number of times the 'entered sequence' appears in any given shoe. Can explain further and provide data-sheet if somebody cares to help.

Not quite sure what your example represents, but it does not matter. We can proceed using simple probabilities. For example for commission baccarat and taking banker, we obtain from Michael's WizardOfOdds web site the chance of win, lose and push are 0.459, 0.446 and 0.095 so the chance of say

WWWW = 0.459^4 = 0.044 or 44 times out of 1000
WLPW = 0.459x0.446x0.095x0.459 =0.009 or 9 times out of 1000

This is for the EXACT order of events. For example the chance of WLPW OR WPLW (i.e. either sequence happening) is 2x0.009

I'm not sure what you're after but I've used various things to extract info into one long list.

Firstly create a column with either [1...N] or {x,y} where say x goes 1-13, y goes 1-13. I use this technique a lot when working out all combos of (say) four cards. Then use OFFSET(cell,a,b) (in my case to get the value of the card from "AKQJT98765432" or Suit "Spades".."Clubs" for display purposes).

Another way - if the data comes in as text is to use LOOKUP to find the blanks and a combination of LEFT RIGHT to extract what you need. (I won't spoil the fun as it takes a while work work out how to do it!).

Quote: egalite

Can anybody assist in producing an Excel macro for me, please?

I have a spreadsheet were Baccarat results are recorded in columns of four (running top to bottom, left to right);

[decisions]
1-5-9
2-6-10
3-7-11
4-8-12 etc

a macro would be overkill IMO,
unless you are doing many shoes at one time and it also can not be undone.

Easy to use CONCATENATE(C2,C3,C4,C5) each column and count them
I do not know how many shoes you have per worksheet but that should easily be adjusted for

here is a file with no macros that takes each column and counts the frequencies of each of the 16 possible sequences
F9 or calculate to see the sheet work
but you can just use the code to fit onto your worksheet.

Bacc-shoe-patterns-4row.xls

Many thanks 7craps, I will play around with this.

Much appreciated...