repeating number list without duplication

Maybe:

Please Login or Register  to view this content.

A classic Excel basics VBA demonstration for starters :

PHP Code: 

Sub Demo1()
  Const C = 3, R = 7
        Columns(7).Clear
    For N% = 1 To C
        With Cells(1 + R * (N - 1), 7).Resize(R)
            .Formula = "=RAND()"
            .Value = Application.Rank(.Cells, .Cells)
        End With
    Next
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

Hi Nightowel23,

Put the numbers 1 to 7 into the range A2:A8, enter 3 in cell B2, ensure the ws variable is set correctly and then try this where it outputs the number of permutations that equal what's in cell B2:

Please Login or Register  to view this content.

Regards,

Robert