Students names are listed vertically in Column A. Column B through some column, let's say P, contain test scores of each student by row, next to their names. 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?

I do not want to transfer everything to column form. I want to keep it in row form horizontally, and order it that way.

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!!!!