There is a feature of Excel that does exactly what you want. Its called a
Pivot Table. You get to it by pulling-down:

Data Pivot Table...

Using it you can organize a table by student by test to give the max of score.
--
Gary''s Student


"abqhusker" wrote:

Is there a formula/function to to this? Each student get 3 attempts at
a test and I take the highest score. I want a formula that will display
the highest score for each student for for each different test...so the
end result will hide the other two lower score and a student's name will
never be displayed twice for the same test. I have no idea how to
approach this or whether it's even possible. I'm thinking maybe an
array or lookup, but maybe it's as simple as a filter. Do any of you
know how to do something like this? I'd appreciate any tips and pointers.

Ed

Spreadsheet:
ColA ColB ColC
StudentName TestName Score
Student1 Test1 60
Student1 Test1 80
Student1 Test1 70
Student2 Test1 40
Student2 Test1 90
Student2 Test1 75
Student1 Test2 50
Student1 Test2 85
Student1 Test2 75
Student2 Test2 55
Student2 Test2 65
Student2 Test2 80
Etc.....