reporting_95
New Member
- Joined
- May 7, 2019
- Messages
- 30
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Hi,[/FONT]
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]I have a workbook that lists all terms attended for each student as well as their GPA for that term in descending order. What I am trying to achieve is target the top entry for each student, which will give me the last term attended as well as their last known GPA. Please see a short example of a much larger list below. [/FONT]
<tbody>
</tbody>
As you can see from the example, the last term attended is always the first entry for each student. I would need Term 5 for John, Term 4 for Jane, and Term 6 for Ben. This would give me their last term attended, and cumulative GPA. I tried filtering out by specific term but that would throw off the numbers because each student's last term attended is different.
Is there a way I can target the top entry for each student? Please kindly advise.
Thanks!!
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]I have a workbook that lists all terms attended for each student as well as their GPA for that term in descending order. What I am trying to achieve is target the top entry for each student, which will give me the last term attended as well as their last known GPA. Please see a short example of a much larger list below. [/FONT]
Student ID | Last Name | First Name | Cumulative GPA | Term |
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]122145[/FONT]<strike></strike> | Smith | John | 3.1 | 5 |
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]122145[/FONT]<strike></strike> | Smith | John | 2.9 | 4 |
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]122145[/FONT] | Smith<strike></strike> | John | 3.45 | 3 |
122651 | Reid | Jane | 3.7 | 4 |
122651 | Reid | Jane | 3.0 | 3 |
122156 | Hayes | Ben | 4.0 | 6 |
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]122156[/FONT] | Hayes | Ben | 3.52 | 5 |
<tbody>
</tbody>
As you can see from the example, the last term attended is always the first entry for each student. I would need Term 5 for John, Term 4 for Jane, and Term 6 for Ben. This would give me their last term attended, and cumulative GPA. I tried filtering out by specific term but that would throw off the numbers because each student's last term attended is different.
Is there a way I can target the top entry for each student? Please kindly advise.
Thanks!!