trifecta output

[barneyboy]

Hello. I'd like to display the combinations of a set of numbers in column A into columns B,C and D. eg: in column A1 to A6 I'd have the numbers 1,2,3,4,5 and 6.
there are 120 combinations of these numbers for a trifecta starting with 1,2,3 and ending with 6,5,4.
Is there a way to express these 120 combinations in columns BCD eg.
the first combination of 1,2,3 would appear in columns B1,C1 and D1 and the rest so on down the spreadsheet.
hope I've made it understandable.

Regards,

barneyboy

 

[Sal Paradise]

a) Will it always be 6 numbers?
b) Does it need to be formulas, or are you looking for a macro?

 

[grizz]

try this

Sub Test()
For B = 1 To 6
    For C = 1 To 6
        For D = 1 To 6
            If B <> C And C <> D And B <> D Then
                N = N + 1
                Cells(N, 2) = B
                Cells(N, 3) = C
                Cells(N, 4) = D
            End If
        Next D
    Next C
Next B
End Sub

 

[barneyboy]

hello, Sal P. No, it will not always be six numbers. Sometimes 4,5 or even 7 or 8 numbers. I do have a formula to include in another column which references the odds that I assign to nos 1 to six in column A
I suppose I am looking for a macro but I don't know how to do it.

Thanks, Grizz, for your reply. I'll try to give it a go.

Many thanks for your replys, guys.

Regards,

Barneyboy

 

[Sal Paradise]

Grizz's formula will do it for 6, but if it's going to be a variable amount, you need to replace 6 with a variable that counts the number of entries in your A column.