How to List All Possible Combination of a Number in Excel

Question

in cell "A1" = 123 and "A2" = 456.

May I know how can I show all the possible combination so that it will look like this:

I tried to search online but cannot find any solution. Any help will be appreciate.

StevenWhite · Accepted Answer · 2013-04-18 22:01:46Z

1

You can use the function below to generate all permutations of the digits in the string.

Sub GetPermutation(x As String, y As String, ByRef CurrentRow As Double)
    Dim i As Integer, j As Integer
    j = Len(y)
    If j < 2 Then
        Cells(CurrentRow, 1) = x & y
        CurrentRow = CurrentRow + 1
    Else
        For i = 1 To j
            Call GetPermutation(x + Mid(y, i, 1), _
            Left(y, i - 1) + Right(y, j - i), CurrentRow)
        Next
    End If
End Sub

For your example you could do:

CurrentRow = 2
Call GetPermutation("",Range("A1").value,CurrentRow)

answered Apr 18, 2013 at 22:01

StevenWhite

6,0443 gold badges25 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

StevenWhite Over a year ago

If you are planning on using this on large scale problems such as permutations of 9 digits, you shouldn't use Excel. I would suggest something like Python instead.

Collectives™ on Stack Overflow

How to List All Possible Combination of a Number in Excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related