Auto Sort

[djp203]

Hi,

Is there a way for data to auto sort?

I have a table with teams and points next to it (no need to mess around with if they are level on points, or goal differences or anything along those lines etc)

Column N20 to N25 are numbered 1 to 5
Coumn O19 is Team with the 5 teams running from N20 to N25
Column P19 is Points with the 5 teams points running from P20 to P25

 

[djp203]

Hi,

Is there a way for data to auto sort?

I have a table with teams and points next to it (no need to mess around with if they are level on points, or goal differences or anything along those lines etc)

Column N20 to N25 are numbered 1 to 5
Coumn O19 is Team with the 5 teams running from N20 to N25
Column P19 is Points with the 5 teams points running from P20 to P25

I should have probably stated, this will change week on week with results being manually put in which will automatically update the table's "Points" which I would like to auto sort. Was just hoping there was a way it could be done so I wouldn't have to select decending order by points.

 

[djp203]

I have just tried doing this by Rank and Vlookup, but have the problem that when the points are the same it shows #N/A

 

[djp203]

any ideas?