creating columns with numbers that become larger

R

Roger Jones

Hi,
I need help making a column in excel that will have a
pattern similar to the example below:

1-3
3-6
6-9
9-12
12-15
15-21
ect. ect.

The numbers don't have to be seperated by a dash, but i
have to make several columns like this with varying values
and cannot determine how to use the fill function to creat
columns like this.

Thanks for your help,
Roger
 
J

J.E. McGimpsey

If this list is going to start in Row 1 then:

A1: =ROW() & "-" & ROW()*3
A2: =(ROW()-1)*3 & "-" & Row()*3

Or you could base each entry on a previous entry. Since your first
digit of the first entry breaks the pattern for the rest (i.e., 1
rather than 0), one way is to base subsequent entries on the last
digit of the first entry:

A2: =MID(A1,FIND("-",A1)+1,15) & "-" & MID(A1,FIND("-",A1)+1,15)+3
 
T

Talekana Krishnadas Rai

The first cell should have a start value. Select the range
for fill. Then go to edit-fill-series, enetr the step value
 
Top