Q __________________ T___________________ U________________V
GD________________Points(ref)____________ Team(Ref)________Team Final Position
2____________________6__________________ESP_______________ING
6____________________7__________________ING_______________ESP
1____________________4__________________ITA_______________ ITA
-9___________________0__________________HOL_______________HOL
The Data Above is for a soccer pool bracket tracker that I am building.
What I need is the following: I want column V to show the teams in column U, ordered by final position according to the number of points they have in column T.
I used this formula to look for the team with more points and it seemed to work. =INDEX(T2:U8,MATCH(LARGE(T2:T8,1),T2:T8,0),2)
Then I simply changed the condition to get the second highest and so on....
However, when there are two teams with the same number of points, the formula stops working.
My questions is: When two teams have the same number of points, how can I make the formula to evaluate column Q which shows GOAL Difference.
For Example: IF ESP and ING had 3 points each, then I want the formula to look for their GD which according to column Q is ESP=2 and ING=6. this would result in ING being first.
I hope someone can help me.
thanks,
Juan Velez
Bookmarks