Ok your results are exactly the same of my actual code …
I asked your results of your largest 4 "ranks" in order to rewrite the rank engine in the code, so which way should I follow ?
In case of yours, the results should be
2005 : 8+5+5+4 = 22
2006 : 9+9+7+6 = 31
2008 : 5+3+2+2+2+2 = 16
or not ?
If I add 10 to your previous sample like 10, 10, 9, 9, 7, 7, 7, 6, 5 so which result is yours :
1) My actual code : 10+10+9+9+7+7+7+6 = 65
2) Like your explanation : 10+10+9+9 = 38 (this case returns exactly same result as largest Excel 4 ranks …)
3) Other one if both previous are wrong !
A) And what could be your expected result from 10, 10, 10, 9, 9, 7, 7, 7, 6, 5 ?
B) And from 10, 10, 10, 10, 9, 9, 7, 7, 7, 6, 5 ?
Bookmarks