Combinations, Permutations

[scantor145]

I have a list of 24 items. For example, boat, chair, table, etc.
I want to find and list all possible combinations of any two(2) of them, and order does matter.

Any suggestions or VB code I can use to automate the process?

Thanks.

[Harald Staff]

Sub test()
Dim L As Long
For L = 1 To 24
Cells(1, L + 1).Value = "item" & L
Cells(L + 1, 1).Value = "item" & L
Next
Range("B2:Y25").FormulaR1C1 = "=RC1&R1C"
Columns("B:L").EntireColumn.AutoFit
End Sub

HTH. Best wishes Harald

"scantor145" <scantor145.1z9eym_1133269801.2923@excelforum-nospam.com> skrev
i melding news:scantor145.1z9eym_1133269801.2923@excelforum-nospam.com...
>
> I have a list of 24 items. For example, boat, chair, table, etc.
> I want to find and list all possible combinations of any two(2) of
> them, and order does matter.
>
> Any suggestions or VB code I can use to automate the process?
>
> Thanks.
>
>
> --
> scantor145
> ------------------------------------------------------------------------
> scantor145's Profile:
> http://www.excelforum.com/member.php...o&userid=14766
> View this thread: http://www.excelforum.com/showthread...hreadid=489040
>