Increment in column field.
 

Hello -

This may seem easy to the Excel gurus out there so I would appreciate your
help.

I need to increment a number starting at 1 from A1:A1256 with it
incrementing just by 1.

1
2
3
4
and so on....

What formula could I use to accomplish this?

thanks,
mark

Increment in column field.
 

I'd put 1 in A1.

Then select a2:A1256 and type =a1+1 and hit ctrl-enter to fill that selected
range.

(Copy|paste special|values if you need to)

MN wrote:

Hello -

This may seem easy to the Excel gurus out there so I would appreciate your
help.

I need to increment a number starting at 1 from A1:A1256 with it
incrementing just by 1.

1
2
3
4
and so on....

What formula could I use to accomplish this?

thanks,
mark

--

Dave Peterson

Increment in column field.
 

Try "=Row()", that way, if you delete a row, the numbers are still sequential.

Dale Preuss



"MN" wrote:

Hello -

This may seem easy to the Excel gurus out there so I would appreciate your
help.

I need to increment a number starting at 1 from A1:A1256 with it
incrementing just by 1.

1
2
3
4
and so on....

What formula could I use to accomplish this?

thanks,
mark