#1
|
|||
|
|||
Create a sequence of numbers using a formula
I’m trying to find a formula to create a sequence of numbers. The starting number would be in A1 and the ending number in B1. So if A1 = 88 and B1= 93 the result in the formula cell (C1) would be 88 89 90 91 92 93. I tried using =Row(Indirect(A1”;”&B1)) and I could get the correct results but I could not figure out how to deal with array results, such as copying the results and using in another application. I found some work arounds to use the array result but when I tried recording this into a macro it did not work correctly so I just want to go to a simple formula. Any ideals? Thanks
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
How to assign numbers to letters and then create a formula to add them together for a rota | Mskapri | Excel | 6 | 04-01-2017 03:05 PM |
Need Help Deleting Numbers in Hour Format and Numbers in Sequence | rsrasc | Word VBA | 1 | 10-12-2016 02:49 PM |
How to Create a Locked Sequence of Buttons | kcackin | PowerPoint | 0 | 01-24-2011 02:43 PM |