Students names are listed vertically in Column A. Column B through some
column, let's say P, contain test scores. There are 25 quizzes with a
maximum score of 10, and 5 exams with a maximum score of 100. These
scores are arranged horizontally going across the row next to the
students name.
How do I arrange the scores, in ascending order (from lowest to
highest) for each student, so that I can delete or drop the lowest five
quiz scores?
For example ( Here are 8 quiz scores. arrange them ascending
horizontally so lowest 5 can be dropped)
1 John Doe 5 8 7 5 10
3 4
2 Amy Smith 4 5 8 10 9
7 5
THANKS!!!!
--
arjun j
------------------------------------------------------------------------
arjun j's Profile:
http://www.excelforum.com/member.php...o&userid=33343
View this thread:
http://www.excelforum.com/showthread...hreadid=531768