Hello all,
I'm trying to set up a ranking that will give the top 3 from highest Total results.
Not sure on the issue but it randomly skips rankings
It should be if 100% pass then the ranking is based of the total, if not 100% the its not taken into consideration.
I have attached a demo doc for view and to help if possible.
Thanks in advance
Column1
=IF([@[Total.]]="","",IF([@[1st Pass%.]]=1,$M8-COUNTIFS($M$4:M8," <> ",$M$4:M8,M8,$N$4:N8,1)/100,""))
RAnK
=IF(Table1[@[Total.]]="","",IF(Table1[@[1st Pass%.]]=1,RANK($V8,$V$4:$V$100,0),""))
Ranking Top
=IF($W4 >3,"",$W4)
Ranking Bottom
=IF($W4 < LARGE($W$4:W100,3),"",$W4)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks for your help, that worked with a slight edit. thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks