creating columns with numbers that become larger

  • Thread starter Thread starter Roger Jones
  • Start date Start date
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
 
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
 
The first cell should have a start value. Select the range
for fill. Then go to edit-fill-series, enetr the step value
 
Back
Top