I'm trying to sort the following League Table by Points, +/-, For... However when there's a BYE in the table and teams with no points and negative goal difference the BYE is ranked higher (the BYE is ranked 5th in the example), how do I stop this from happening ? I have attached a sample file
The unique number formula upon which the ranking is based is - =K3*10000+J3*1000+H3*100+E3*10
The Ranking formula is - =RANK(L3,$L$3:$L$8)+COUNTIF($L$3:L3,L3)-1
Any help will be greatly appreciated...
I am really not sure if this is what you want. it's a bit inelegant, but you can always hide the helper row. Take it for a test drive & let me know...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
HiOriginally Posted by kevinmcilroy
Cell L3copy downFormula:
Please Login or Register to view this content.
Cell B3copy down.Formula:Please Login or Register to view this content.
Bye just be a blank instead Ranking number!
Regard
micope21
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Thats great, thank you guys...
You're welcome & thanks...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks