now heres the REAL question

[BigTomatoes]

 is there a formula which gives all the combinations ?

[Jim-D]

To what?

[BigTomatoes]

 8 matches = 6561 outcomes

 is there a formula to work out all the combinations

[gatso]

This is easy in spreadsheet form

You need one with 8 columns each of 6561 rows (or 8 rows of 6561 columns if you prefer)

with H=home, A=away and D=draw

column 1 reading sown should be H,A,D,H,A,D,H,A,D etc all the way to the bottom

column 2 HHH,AAA,DDD,HHH,AAA,DDD,HHH etc

column 3 HHHHHHHHH,AAAAAAAAA,DDDDDDDDD,HHHHHHHHH etc. (9 of each letter)

column 4 same as before but with 27 of each letter

column 5 same again but 81 of each letter

column 6 243 of each letter

column 7 729 of each letter

column 8 2187 of each letter

shouldn't take too long to set up in excel if your familiar with clicking and dragging on columns

[BigTomatoes]

 CHEERS MATEY