Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically increment field by one | Excel Discussion (Misc queries) | |||
How do I add increment a text field value? | Excel Worksheet Functions | |||
increment a column based on information in another column | New Users to Excel | |||
Method to increment value in data field? | Excel Discussion (Misc queries) | |||
Method to increment value in data field? | Excel Discussion (Misc queries) |