Hi All,
I'm having a problem and I hope you can help.
If you look at the raw data, you see grades of 3 students in 10 different classes.
I want to write a formula that picks the best 3 grades of each student in each class (this means each class can be presented only once)
For example, John's best grade is in Bible (95) but Daniel has a better grade in Bible (98) so the results will ignore John's grade in Bible and will look for his second highest grade (in this case it's Chemistry).
I've calculated how the results should look like (table on the right side) but this was done without formula since it's too complicated for me.
I hope someone here can tell me how the formula should look like.
Thanks in Advance,
Nircom
http://i292.photobucket.com/albums/mm36/nirosy/excel problem_zpschmoiasl.jpg
I'm having a problem and I hope you can help.
If you look at the raw data, you see grades of 3 students in 10 different classes.
I want to write a formula that picks the best 3 grades of each student in each class (this means each class can be presented only once)
For example, John's best grade is in Bible (95) but Daniel has a better grade in Bible (98) so the results will ignore John's grade in Bible and will look for his second highest grade (in this case it's Chemistry).
I've calculated how the results should look like (table on the right side) but this was done without formula since it's too complicated for me.
I hope someone here can tell me how the formula should look like.
Thanks in Advance,
Nircom
http://i292.photobucket.com/albums/mm36/nirosy/excel problem_zpschmoiasl.jpg
Attachments

90.6 KB Views: 13