Distributing values or data with a group???

[FifiNguyen]

I'm creating an academic advising form that tracks a college student's progress, and remaining hours needed for graduation. So far the form lists courses that are still missing for graduation, and needed credit hours that determine how many semesters the student has left. For example a Freshman who just completed their first semester at college (13 credits) would have 117 credits left, or approximately 7 semesters.......Can I get excel to distribute student courses evenly (or close to) for these remaining 7 semesters? If so, is there a way to make sure MAJOR Courses stay listed under at the end of the 7 remaining semesters. Thanks for your help!

Moderator's note: Moved thread from Hello...Introduce Yourself --6StringJazzer