How to sort soccer league tables for World Cup spreadsheet. VLOOKUP? RANK?

**daveycmc** · 05-14-2010, 08:27 AM

I posted this a few days ago, but the help I received didnt answer my question, so I am posing the conundrum in another way.

I need the table in the picture (http://i42.tinypic.com/2h2jdcx.jpg) sorted by:

Points, then if points are equal for two or more teams
Goal difference, then if points and goal difference are equal for both teams
Goals scored

There must be an easy way out there to do this, and it is just a total clutz like me cant get my head around it?

Any help received would be greatly appreciated.

Thanks in advance.

Also, sample spreadsheet is uploaded in post number 3.

**day92** · 05-14-2010, 09:20 AM

Dave - I picture does us no good, please update some sample data.

**daveycmc** · 05-14-2010, 09:40 AM

Originally Posted by day92

Dave - I picture does us no good, please update some sample data.

I have copied my spreadsheet onto a sample layout and attcahed for your perusal.

Basically I need to automatically sort the yellow highlighted table at Ref. BO7, so that it will sort autimatically based on points, then if need be goal difference, then finally if teams still tied, goals scored.

Hope you can help, I am going crazy here.