[SOLVED]Ranking

Originally Posted by seahawks3726

Your equation worked great except when i have a tie

Yes, the prior suggestion (as outlined) is reliant on unique identifiers.

To account for duplicates in terms of rank and assuming that the names (B5:B230) are themselves unique then:

Q17: 
=INDEX($B$5:$B$230,MATCH(1,INDEX(ISNUMBER($E$5:$E$230)*($E$5:$E$230<=ROWS(Q$17:Q17))*ISNA(MATCH($B$5:$B$230,$Q$16:$Q16,0)),0),0))
copied down

it is imperative in the above that Q16 does not contain the name of any team in the B5:B230 listing.