![]() |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
||||
|
||||
|
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 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
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |