View Single Post
 
Old 03-16-2018, 10:39 PM
14spar15 14spar15 is offline Windows XP Office 2000
Advanced Beginner
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default 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