I work for a college. My students study 5 classes through a 5 semester program, however they can mix their classes/semesters around, not necessarily studying classes 1-5 in order.
I have created a summary page where I record their name and their start date for each class. On the worksheet there are also tabs relating to each semester which will provide me with a snapshot of who is enrolled in each class in that particular semester.
I know I can use filters on the summary page to see who is in a particular class, however I want to use formulas to populate class lists with names so I can view all the class lists at once for any given semester.
I have uploaded a very simplified version of the worksheet.
I would like the table at the bottom populated with lists of names based on who is in which class in Jan-13, however I can't seem to get any formulas to work for me to do this.
Any help would be greatly appreciated!Test.xlsx
Bookmarks