Ok... I have a gradebook, with a column of names, plus multiple columns of test grades. I am making a table that includes 3 columns: Test # / Student Name / Grade In the grade column i have put the highest grade made on each test, I have done that with the MAX function, but now I need to include the student name that goes along with that grade. I don't want to just type it in, so that in case i need to change the highest grade,the name will automatically change with it. Any ideas??
Hi rae,
You can most like use an INDEX/MATCH formula to pull in the student's name, however, what if there is a tie for high score? Do you want just the first student with that score in the list, or the last student, or all students with that score?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks