Sorting a Column and it's Adjacent cell!!!

**Ddefatta** · 04-18-2013, 10:09 PM

I have list of names of people in a billboards league. Directly to the right of everyone's name in the adjacent cell is their "win percentage". I need these percentages sorted in descending order and I need the names to move along with the adjacent cell as the percentages change. BUT I WANT/NEED A FORMULA that updates the cells automatically. Any suggestions on formulas to help do this!?! Thanks!! Also i attached a screen shot of the area im working in, and then the file itself should be attached also.
Screen Shot 2013-04-18 at 6.56.53 PM.png
THE LEAGUE (version 1).xlsm

-Dylan

**FDibbins** · 04-19-2013, 01:38 AM

Hi and welcome to the forum

try this suggestion. Because the values you are using are so widely distributed through-out your table, make a small 2-column table somewhere (doesnt matter where, we will hide it later - I used A58:B65) and enter...
=D11...Dylan
=D21...Troy
=D31...Jose
=D41...Fabian
=O11...Poma
=O21...Omar
=O31...Fidel
=O41...Tim

Then in your league table, for the % entere this, copied down...
=LARGE($A$58:$A$65,ROW(A1))

and for the names, use this, copied down...
=INDEX($B$58:$B$65,MATCH(L58,$A$58:$A$65,0)*1)

the table you just created can go anywhere you want, and if you want, you can put it off to the side and then hide the columns, or leave it where it is and make the text font white so it goes "invisible"

**Ddefatta** · 04-19-2013, 08:52 PM

This is great! thanks a lot, but in the INDEX formula, what does the purpose of the L58? Also, when I copy that formula down, will I change the "0" to a 1,2,3...etc, or the "*1" to a *2,*3,*4....etc?