| 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) | |||
Hybrid Mode
