consecutive numbering

[rafonss]

I would like to start numbering 1 - 500 in a column and 1 - 30 in a row. Is
there some way to do this with a function?

 

[Pete_UK]

There are many ways of achieving this, but if you want a function then
the easiest is to put 1 in your starting cell (suppose this is A1) and
then in A2 put this formula:

=A1+1

and copy this down.

In B1 you can enter this formula:

=A1+1

and copy this across.

Hope this helps.

Pete

 

[Dave Curtis]

Hi,

Try using =COLUMN() or =ROW()

Dave

url:http://www.ureader.com/msg/104238531.aspx

 

[Milan L]

Hi,
this did not work for me. Copying =A1+1 in A3 always give me 2 instead of
number 3. am i reading your note correctly? thanks

 

[David Biddulph]

If you copy cell A2, containing =A1+1, down into A3, the formula will become
=A2+1.

 

[Glenn]

Another option...in the first cell of the column you want to number from 1-500 put

=ROW(1:1)

and fill down as needed. In the first cell of the row you want numbered from
1-30 put

=COLUMN(A:A)

and fill right as needed.