Problem
I need some help with a formula that will start in cell C6 and continue through L6 and will provide the participant's ranking within the group.
Scenario
- Name 1, Name 6 and Name 7 have the same number of correct guesses, therfore they are tied
- So if we look at the "Tiebreaker" row, Name 1 and Name 6 got it correct.
- Since they tied on both, they would both be ranked #1.
- All others will be ranked based on the correct guesses
Sample workbook attached.
Last edited by maddog9486; 09-16-2011 at 08:12 AM.
Maybe include a score row based on...
filled across the table.
Please Login or Register to view this content.
The standard RANK function applied to these scores returns the ranks you are after...
filled across the table (assuming the score row is row 23).Please Login or Register to view this content.
Beau Nydal
Thanks Beau. This appears to work perfectly.Originally Posted by beaunydal
Maybe include a score row based on...
filled across the table.Please Login or Register to view this content.
The standard RANK function applied to these scores returns the ranks you are after...
filled across the table (assuming the score row is row 23).Please Login or Register to view this content.
Beau Nydal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks