#1
|
|||
|
|||
Sequence numbers with Excel 2010
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 |
|
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 |