#1
|
|||
|
|||
Counting Grades on Excel Spreadsheet
There is a large MS Excel spreadsheet with the following information in separate columns:
1. 1. College names. 2. 2. Student names. 3. 3. Grades A to F for each examination they have taken (8 exams in total). The grades are in letter format rather than figures. What function do I use on MS Excel to calculate: (a)· Which student obtained the greatest number of ‘A’ grades? (b)· Which college obtained the greatest number of ‘A’ grades? I have been going through various methods to solve this but without success. Any help would be much appreciated. Thanks |
#2
|
|||
|
|||
Pivot tables could do this to and lots more.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't Open Excel Spreadsheet | Lucky Luke | Excel | 0 | 03-12-2015 12:47 PM |
Labels from excel spreadsheet | Shepherdra | Mail Merge | 5 | 12-11-2014 11:26 PM |
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook | JaxV | Excel | 9 | 11-14-2014 12:25 AM |
Powerpoint Quiz/Test advanced - Getting Grades or Results from Questions in show | Pete1 | PowerPoint | 1 | 05-17-2014 05:54 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |