ranges in excel???

M

mp

Is there any way to put a range into excel, i.e. 1 to 10,
and have it spit out data points at evenly spaced
intervals between the two numbers. (in this case, I would
put in 1-10 and excel would spit out 1,2,3,4,5,6,7,8,9,10.

Thanks,

mp
 
F

Frank Kabel

Hi
one way (if you put this in cell A1): Enter the following in B1
=IF(--LEFT(A1,FIND("-",A1)-1)+ROW(1:1)-1<=--MID(A1,FIND("-",A1)+1,10),-
-LEFT(A1,FIND("-",A1)-1)+ROW(1:1)-1,"")
and copy this down for as many rows as you need
 
Top