# Get excel to list teams automatically (without having to press sort button)

#### frnkmurphy

##### New Member
Hi guys, have searched for this, but am really struggling!

I have a list of teams and a list of points. I need to copy this list further down the page, but have excel automatically list the teams in order of their points. (Without pressing the auto sort!!)

I have managed to rank the number of points, and have used vlookup to get the name of the team next to the value in points. (By getting it to look up the cell with the highest value, and then second highest, using =max() and =large(x:x,2)) It looks like this:

16 Team 1
12 Team 2
12 #N/A
11 Team 4
9 Team 5
9 #N/A

The problem as you can see is that when there are more than one team on the same points, it can only find the first one.

Can anyone help me? I have made a list next to the teams, putting them in alphabetical order, and thought that I might be able to rank first against points and then against the name, but not sure how I would get along with that, as the vlookup is looking for the first, second, third etc value of points. I can email someone the spreadsheet if that helps!!

Hope you can make sense of that!!! Thankyou very much for any insight.

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
You need a ranking system that takes duplicates into account, like C3 does in this chart. Then regular INDEX/MATCH formulas can re-sort your list automatically:

Excel Workbook
ABCDEFG
116Team13RawRankedTeam1323
212Team27Team1922
312Team38Team116
411Team410Team1816
59Team513Team1114
69Team614Team1214
711Team711Team212
89Team815Team312
93Team920Team1612
104Team1019Team411
1114Team115Team711
1214Team126Team1711
1323Team131Team59
145Team1418Team69
156Team1517Team89
1612Team169Team207
1711Team1712Team156
1816Team184Team145
1922Team192Team104
207Team2016Team93
Sheet3

Thankyou very much, i've been messing around with that for weeks!!

Replies
5
Views
201
Replies
5
Views
2K
Replies
1
Views
163
Replies
3
Views
528
Replies
0
Views
139

1,202,987
Messages
6,052,939
Members
444,616
Latest member
novit19089

### 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