Check the last 5 grades student has received

Hi all,

I'm wondering if someone can help me. I have very big spreadsheet with a long list of students and the last 10 exam grades they've received.

What I want to do, based on the criteria of the students name, is pull the last 5 grades they got (newest to oldest). The list will change over time and the grades they received will drop off and they will get new grades. So basically when I add a new grade, the oldest grade will drop off because I only ever need the last 5 results. It would help if I could see Grade 1 (being the oldest) through to Grade 5 (being the newest).

I hope that makes sense. Any help would be massively appreciated.

Thanks