What am I doing wrong here. Whenever I have a tie in my rankings, my top 10 list shows #na. I know that it's something simple, but I just can't see the issue.
Thanks...
What am I doing wrong here. Whenever I have a tie in my rankings, my top 10 list shows #na. I know that it's something simple, but I just can't see the issue.
Thanks...
Hi,
The problem seems to be when you have duplicate values in your overall total.
By adding a new column I have been able to establish unique values.
See what you think.
Cheers
Tony
Nice Tony...
I would just add to your solution:
For extra column you can use also this: =F3+COUNTIF($F$3:F3,F3)/100
For table ROWS function is better: INDEX($J$3:$J$79,MATCH(ROWS($B$3:B3),$H$3:$H$79,0)
Edit: Also, not clear what if there's more people with Total 68 (in this example)... Here is first one prefered (Rick Hardin)... What with others?
Last edited by zbor; 04-12-2010 at 02:03 AM.
This can be achieved without helpers if preferred ?
C3: =SMALL($F$3:$F$79,ROWS(C$3:C3))
copied to C12
B3: =INDEX($I$3:$I$79,MATCH(1,INDEX(($F$3:$F$79=$C3)*ISNA(MATCH($I$3:$I$79,$B$2:$B2,0)),0),0))
copied to B12
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
... and would you use a counta(H:H)-1 instead of
=LOOKUP(9.99999999999999E+307,H:H)?
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Thanks everyone...I appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks