| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I increment a column in Excel
Have a column of 318 members in a club. Want to increment the entire column
by one for each additional year they are active. How do I do this with the operations available in Excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I increment a column in Excel
What's in that column?
If it's just a number/counter: Put 1 in an empty cell Edit|copy that cell select the range to adjust Edit|paste special|check Add and Values Clean up that cell with the 1 in it. Legion Man wrote: Have a column of 318 members in a club. Want to increment the entire column by one for each additional year they are active. How do I do this with the operations available in Excel? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I increment a column in Excel
A more permanent method is to store each person's start date in the club.
Then use Datedif or similar formula to calculate the number of years from Today. Then it will always be accurate, and you won't have to make changes in the future. Regards, Fred "Legion Man" <Legion wrote in message ... Have a column of 318 members in a club. Want to increment the entire column by one for each additional year they are active. How do I do this with the operations available in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increment column values | Excel Discussion (Misc queries) | |||
| Increment column on drag down | Excel Discussion (Misc queries) | |||
| HOW TO: Increment column by7 but row stays same into new column? | Excel Discussion (Misc queries) | |||
| Increment numbers in a column | Excel Discussion (Misc queries) | |||
| increment a column based on information in another column | New Users to Excel | |||
Linear Mode
