Hello.

I have a data set that looks roughly like this (notice the duplicate records per student, sometimes there are 3+ per student):

Student Score Date
1 34 31-Jan
1 54 26-Jan
2 65 26-Jan
2 76 31-Jan
3 45 3-Feb
3 67 31-Jan

I am looking for an automated way (macro or formula) to return the score per student based on the following criteria:
1. highest score
and when the scores are the same for each of an individual student's records:
2. most recent date
and when the scores and dates are both identical for the same student's records, a 3rd criteria and so on.

Thanks in advance!!!