Table Rank & Sort Formula...

[Andrew_OC]

Hi,

Been banging my head against a wall looking for a suitible formula for a small task on google so I hope there's someone here that can help!

I need a formula that can help sort the following :

Andrew_________30
Bill_____________10
Charlie__________40
Dave____________25
Edward___________25

into elsewhere on the sheet :

Charlie_______40
Andrew_______30
Dave_________25
Edward_______25
Bill___________10


can anyone help ???

 

[Domenic]

Assuming that A2:B6 contains the data, try...

E2, copied down:

=LARGE($B$2:$B$6,ROWS($E$2:E2))

D2, copied down:

=INDEX($A$2:$A$6,SMALL(IF($B$2:$B$6=E2,ROW($B$2:$B$6)-ROW($B$2)+1),COUNTIF($E$2:E2,E2)))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!