Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easy question: Sort ascending in a row?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Easy question for you, but hard for me. | Excel Worksheet Functions | |||
sort data by criteria other than ascending or decending | Excel Worksheet Functions | |||
easy question .... i think | Excel Discussion (Misc queries) | |||
Lookup and Sort Question | Excel Discussion (Misc queries) |