I am trying to sort some marks in order to figure out the mark average. The students have 4-8 classes and these all have to be included in the average. I can sort the data by student number (which is unique for each student) and get all the courses for each student together. Here is what I would like Excel to do:
1. Search through the student number column and find all the courses for Student-A.
2. Grab all of the marks for those courses that are listed in another column (Marks) -- for Student-A
3. Average out all of the marks in order to calculate the student's average mark (A Honours/B Honours) and place that in a third column
4. I also need to search out effort or study habits (Excellent, Good, Satisfactory, and Needs Improvement) in another worksheet. Students who get all excellent or good - receive an award. Those that get a satisfactory or needs improvement in at least 1 of their courses are disqualified from the award. The same sorting method for the marks could be used - if possible - search out all courses for the student number (1 column), check their effort habit value (2nd column) and put a yes or no in another value (3rd column).
5. I would like to do this for several hundred students so there is a lot of information
I have been trying to organze it in Pivot Tables and display the information. I don't have to organize it in Pivot Tables - someone told me it would work...not the case! I do not know whether this is possible or not.
Any help with this situation is greatly appreciated. Thanks in advance.
Beaner
Bookmarks