# Table Rank & Sort Formula...

#### Andrew_OC

##### New Member
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 ???

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
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!

Replies
5
Views
362
Replies
3
Views
285
Replies
1
Views
172
Replies
6
Views
289
Replies
3
Views
208

1,203,483
Messages
6,055,679
Members
444,807
Latest member
RustyExcel

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back