Sequence numbers with Excel 2010

14spar15 · #1 04-13-2023, 12:25 PM

Hello, it seems the SEQUENCE function is not on Excel 2010. Is it possible to sequence numbers between A1 and B1 on D1 with a formula in this sample attachment....Thanks

p45cal · #2 04-13-2023, 01:55 PM

Quite surpries you want this in one cell.
In the attached formula in cell D2:
=InCellSeq(A1,B1)
supported by UDF:

Code:

Function InCellSeq(Start, Finish)
For I = Start To Finish
  myStr = Join(Array(myStr, I))
Next I
InCellSeq = Application.Trim(myStr)
End Function

There's also another UDF used in cell(s) K2:R2 which uses this UDF, stolen from : UDF for sequence function | MrExcel Message Board ):

Code:

Function ArrSeq(lRows As Long, Optional lCols As Long = 1, Optional lStart As Long = 1, Optional lStep As Long = 1) As Variant
Dim R As Long, C As Long, Nums As Long
Nums = lStart
For R = 1 To lRows
  For C = 1 To lCols
    ArrSeq = ArrSeq & "," & Nums
    Nums = Nums + lStep
  Next
  ArrSeq = ArrSeq & ";"
Next
ArrSeq = Evaluate("{" & Replace(Mid(Left(ArrSeq, Len(ArrSeq) - 1), 2), ";,", ";") & "}")
End Function

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How-To? Daily Data / Repeating Day Sequence in Excel 2010	jomar	Excel	1	02-12-2019 03:30 AM
Create a sequence of numbers using a formula	14spar15	Excel Programming	9	03-19-2018 01:15 AM
Sequence numbers after each print	MauricioPillon	Excel	0	02-15-2018 08:11 AM
Wildcards - Sequence of Numbers at the Beginning of Each Paragraph	qubie	Word	1	11-30-2017 02:03 PM
Need Help Deleting Numbers in Hour Format and Numbers in Sequence	rsrasc	Word VBA	1	10-12-2016 02:49 PM