Hello everybody
Thank you in advance for your help
As you can see in the attacment, I've almost solved my problem
this two formulas are working great
in G2
=LARGE($D$2:$D$11,ROWS($G$2:G2))
In H2
=INDEX($A$2:$A$11,SMALL(IF($D$2:$D$11=G2,ROW($A$2:$A$11)-ROW($A$2)+1),COUNTIF($G$2:G2,G2)))
But i'm stuck when two teams have the same points, i need that the teams that won more matches stay Up in the rank
I hope is clear
PS I would love to keep the same approch of formula and not helper colunms
Thank you
Bookmarks