excel formula?

[tomski]

can anyone tell me the formula (and how i put it in)
so my league table will list in the correct order. it lists in the correct order by points but teams with better goal difference are in the wrong place how do i combine the reults from each column so that teams with the same points are in goal difference order ?

[GAVIN W]

As you have already got the table running I presume you know how to creste or alter the formula. Therefore what you need to do is use the "if" function in the formula to put if the points column is the same it goes to goal dif. but this will have to be done on every placed team so that the formula will work if there are any clashes.

Dont use the sort function, that would mean manually doing it every time and thats not how to use excel properly.

www.freesamsungtv.co.uk