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?

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

On Sep 4, 11:44*pm, rafonss wrote:
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?

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

"Pete_UK" wrote:

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

On Sep 4, 11:44 pm, rafonss wrote:
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?

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

Milan L wrote:
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

"Pete_UK" wrote:

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

On Sep 4, 11:44 pm, rafonss
wrote:
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?

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.


Milan L wrote:
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

"Pete_UK" wrote:

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

On Sep 4, 11:44 pm, rafonss wrote:
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?

Hi,

Try using =COLUMN() or =ROW()

Dave

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