How do I increment a column in Excel

  • Thread starter Thread starter Legion Man
  • Start date Start date
L

Legion Man

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?
 
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.
 
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
 
Back
Top