Counting Number of Students Registered per Semester

abrand

New Member
Joined
Sep 14, 2010
Messages
2
I'm looking for an easy way to take a student's academic plan (for the next 2-4 years) and match the classes that they take with the semester they take it, and then do that for 175 other students and counting. The semesters will change depending on the students, but they all take the same classes with the exception of one elective course.

From what I've read, it seems like it would be a pivot table, but I can't wrap my head around how to make it work. All the files are based off the same template. When a student is beginning this program, their coursework until graduation is mapped out for them. Then, to get an idea of how many students will be in each course each semester, we have a separate spreadsheet that I manually add "1" for each time a semester matches that course.

I've been looking over these forums for the last few days and can't figure out if the answer is a pivot table, VBA to run a folder sweep (all the students' academic plans are in the same folder, with only that file type in there, but the names are either "student name_student#.xls" or "student name_semester.xls" so a bit inconsistent), or just some CSE formula.

For the record, I switched to an anthropology major in college when I got a B in Visual Basic with my parents' help haha. So I'm now pretty far outside my element.

Any help is greatly appreciated, and let me know if more information is needed. If it would help having the template and the current course registration table I am using, I can upload them if I can figure out how.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

abrand

New Member
Joined
Sep 14, 2010
Messages
2
After I posted this help request, I saw what a mess the folder was in. There have been updates to students' academic plans, and the new copies are also saved in the main folder. However, the template looks slightly different. It still contains the same information pertinent to my problem, but it means the cell locations would be different. In addition, since some students have more than one plan (original and updated versions) in the folder, I would only want to count the most recent.

One plan per student in the folder (the most recent), plus any that are added after the fact would need to be counted by the summary sheet.
 
Upvote 0

Forum statistics

Threads
1,186,647
Messages
5,958,968
Members
438,387
Latest member
faxeur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top