software

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: www.excelforum.com/member.php...oamp;userid=33343
View this thread: www.excelforum.com/showthread...hreadid=531768Hi Arjun,

If you highlight one of the rows and go to Data -gt; Sort -gt; Options.
Here you can choose Sort Top To Bottom or Sort Left To Right.. Choose
Sort Left to right. Click Ok and choose Ascending and click OK.

Regards,
BondiHi Arjun,

If I understand correctly your data starts in B2 ...
following should do the job :

Sub Macro1()
Dim i As Integer
Dim Lr As Integer
Lr = Cells(Cells.Rows.Count, quot;Bquot;).End(xlUp).Row
Range(quot;B2quot;).Select
For i = 2 To Lr
Range(Selection, Selection.End(xlToRight)).Select
Selection.Sort Key1:=Selection.Cells(1), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
Next i
Range(quot;A1quot;).Select
End Sub

HTH
Cheers
Carim
Carim,

Would you mind simplifying your response? I don't really understand
where to put that, or how to use that formula as I am new to excel!

Thanks!--
arjun j
------------------------------------------------------------------------
arjun j's Profile: www.excelforum.com/member.php...oamp;userid=33343
View this thread: www.excelforum.com/showthread...hreadid=531768