finding the greatest number

[jpc036]

I have 38 names on my spread sheet and they took 3 tests, i need to pick out which student got the greatest test grade on each test and have their name and grade posted in two seperate cells. i was wonder if it is possible for me to use a function such as: =Lookup(C2:C38.....) to look up all the grades in my c column(test1) but i dont know how to tell it to pick out the greatest number. I also am confused on how to tell it to print the students name once i have found the greatest test grade. plz and thank you for any help

[jpc036]

ok i found out how to get the greatest number, still looking on how to print the name though

[Dav]

Well you use something like =index(a:A,match(max(c:c),c:C,0)) if the names are in column A and the test scores in c:C) it assumes there are no ties

Regards
Dav

[jpc036]

modified it a little bit and works just fine! thx for the help, i wasnt sure what fx to use