Advanced Search

Question: Sort Two columns but only one descending

Question:Sort Two columns but only one descending

MrMarc 3163 Maple
October 13 2008
0

hi,

I have two columns as seen below. I want to sort column Y in descending order but I want to                                                                      return the the X value of such a Y value as well.

 X         Y

 5        0.9

 3        0.99

 6        0.8

 2        0.85

 etc      etc

 

The solution should look like

X         Y

 3        0.99

 5        0.9

 2        0.85

 6        0.8

 etc      etc

 

Any suggestions?
Please Wait...