Why not just Copypaste special values the original list, then sort the new
list (C & D) by D in descending order?

Not clear why you want to use formulas for this or what you are trying to
learn with the new list....


"Chris" wrote in message
...
Dear all,

I have a list of data in 2 columns: Column A stores 1000 names of
students and Column B stores the scores of the corresponding students. If
I
want to make a sorted list of data in Columns C and D with descending
scores, what formulas should I use in columns C and D? It should be noted
that some students may get the same score. The order of these students in
the sorted list is not important as long as they are in adjacent rows.

Best Regards,
Chris