Automatically Increase Grade every School Year

G

grade?

I have a contact sheet for a youth group that includes their current grade
(e.g. 6th). Is there a way for Excel to manually increase this grade number
every July, rather than having to update it myself? Thanks.
 
B

Bernard Liengme

If the data is cardinal (6) not ordinal (6 th):
Type 1 in any unused cell
Copy this cell
Selected all the cell with data to be incremented; use Edit | Paste Special
with Add specified
Delete the 1 from the temporary position
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering failed moving on...HELP 2
Copying the colour of one cell to anothers. 0
Query for Export 1
Automatic emailing Excel content via Outlook (for Student grading) 2
Count(*) 1
Converting a letter grade to a numerical value 3
Excel formula to incrementally increase a value by 1 every 365 day 2
Need to determine where a change in table occurs 6

Top