Hi
I need help on creating a data set.Can I create the data in columns(E) and columns(F) using cols(A and B) with a formula? Basically I want to create a continuous series between 1-16 and put nothing for non existing periods..
thanks
regards
m.
Hi
I need help on creating a data set.Can I create the data in columns(E) and columns(F) using cols(A and B) with a formula? Basically I want to create a continuous series between 1-16 and put nothing for non existing periods..
thanks
regards
m.
Re: Creating A Data Interval
Perhaps something like this:
Sub InsertMissingNums()
Dim r As Long
Application.ScreenUpdating = False
r = 2
Do Until Cells(r, 1) = ""
If Cells(r, 1) + 1 <> Cells(r + 1, 1) And Cells(r, 1) < Cells(r + 1, 1) Then
Rows(r + 1).Insert Shift:=xlDown
Cells(r + 1, 1) = Cells(r, 1) + 1
End If
r = r + 1
If r > 1000 Then Exit Sub ' Infinite Escape
Loop
Application.ScreenUpdating = True
End Sub
Display More
Re: Create Numeric Series Based On Number Order
Tom thank you very much!
Regards
m.
Don’t have an account yet? Register yourself now and be a part of our community!