Incremental numbers in one cell || Office 2016

[arjun5ne]

Dear Team,

I need help on excel formula how to display incremental numbers in one cell.

Example: 7 increment i.e. 7 14 21 28 35 42 49 56 63 70 - - - - - -

but in one cell display till 49 number only i.e. i need to use CONCATENATE till 49

 

[kevin9999]

A little more compact...

Function Steps(StartNo As Long, EndNo As Long, Jump As Long) As String
  Dim X As Long, S As String
  For X = StartNo To EndNo Step Jump
    S = S & " " & X
  Next
  Steps = Trim(S)
End Function

Very nice Rick!

 

[kevin9999]

You're welcome. Hope you got something that was useful.

BTW, what is the issue regarding versions?

Also BTW, another UDF option

Function Steps(StartNo As Long, EndNo As Long, Jump As Long) As String
  Steps = Join(Filter(Application.Transpose(Evaluate(Replace(Replace("if(mod(row(#:^)-#," & Jump & ")=0,row(#:^),""x"")", "#", StartNo), "^", EndNo))), "x", False))
End Function

Also very nice Peter!