I want to make this in excel
1, 1, 2, 1, 2, 3, 1, 2, 3, 4, 1,2, 3, 4, 5, etc
Do you know how to use VBA? Would make it easy.
Open a blank workbook. Open the VBA IDE (Alt + F11) then paste this code into a module. Press F5 to run it.
Sub sequences()
row_counter = 1
For i = 1 To 100
For j = 1 To i
ActiveSheet.Cells(row_counter, 1) = j
row_counter = row_counter + 1
Next
Next
End Sub
Thanks. your input was very useful