Thread: [Solved] Create a sequence of numbers using a formula
View Single Post
 
Old 03-17-2018, 03:50 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If you want the numbers between value in A1 and value in B1 as an array, try:

=ROW(INDIRECT(A1&":"&B1))

This formula does not require array-entering.
Select the cell with above formula and press F2, then F9 and you should see the numbers between 88 and 93 if you have 88 in A1 and 93 in B1.