Have no idea if I can do this or how, my Excel skills are pretty basic;
help much appreciated. I have a series of tests and want to get the
highest score from multiple attempts by multiple students. I can create
a table like this:

test1 joe doe 95
test1 joe doe 85
test1 joe doe 75
test1 jane doe 96
test1 jane doe 82
test1 jane doe 83
test2 joe doe 92
test2 joe doe 86
test2 jane doe 93
test2 jane doe 76
.. . .

And want to end up with this:

test1 joe doe 95
test1 jane doe 96
test2 joe doe 92
test2 jane doe 93
.. . .

The next step would be to calculate averages per student, i. e. average
of all of joe doe's tests, average of jane doe's test. etc.