Does anyone know a formula that can rank 5 months and give a final rank with a tie breaker?
Does anyone know a formula that can rank 5 months and give a final rank with a tie breaker?
I think you will need to give a lot more detail on this?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
so i have 5 months February March April May June, each with points. I did rank of the points combined and as a tie breaker. I tried ranking each month to return a final rank.
Formula used:
I've applied a sheet to show.Please Login or Register to view this content.
Im still not really sure what your expected answer is, but for the tie break, use this instead...
=L3+(COUNTIF($L$3:L3,L3)/100)
Hi
You could work out ties break by how many between 90 to 100 next 80 to 90 so on
formula for this N3copy downFormula:Please Login or Register to view this content.
L3Formula:Please Login or Register to view this content.
Sample: column F: Total points F5 got 420 point got 2 between 90 to 100? F22 also got 420 point but got 3 between 90 to 100? That make F22 rank 1 F5 rank 2?
IS this something you looking for?
Regard
micope21
Last edited by micope21; 07-15-2014 at 02:07 AM.
To help you by my post? it would be nice to click on to 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".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks