Tuesday, July 24, 2012

yogi_Generate A List Of Numbers Given Starting And Ending Sequence As Specific Numbers Or Via Range Names

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #653   Jul 24, 2012     www.energyefficientbuild.com.


user Chrisnetika said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Mji-S-FK89I)
Creating Array To list a range of numbers
Im trying to list specied range as an array.
Basically I have 2 cells for example A1 and A2, A1 countains number 23 and A2 contains 44
I want to build an array so that in a column each row has number from that range.. for example
               A          
1             23              
2             44
3
4      =Arrayformula(A1:A2)
5             23
6             24
7             25
8             26
9             ... and so on till 44

--------------------------------------------------------------------------------------------------------
following is a solution to the problem