Combinations, Permutations

S

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) o
them, and order does matter.

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

Thanks
 
H

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
 
Top