FreakyGirl
Member
Hello
Can someone pls look & see why the forumla works in AF12 & AF13 but doesnt work in AF38 & AF39 !
The formula in AF looks for a tie & if one is found does the following:
- checks games played in M column to see if its the same for both tied players.
- if the same number, then it puts the total points in column K at the end of the original tied number
- if not the same number, then it puts a 00 at the end.
This is the formula in AF12 is as follows:
In AF12 & AF13 - works perfectly. games played was the same number so it took the scores of 61 & 57 & applied it to the end breaking the tie.
In AF38 & AF39 - even thou the games played are the same number its putting a 00 instead of 43 & 42 keeping the tie going & giving wrong results.
The player in H39 should be ranked higher than the player in H38 because a score of 43 is higher than 42.
What am I not seeing?
Any help is greatly appreciated.
Thanks,
FreakyGirl
Can someone pls look & see why the forumla works in AF12 & AF13 but doesnt work in AF38 & AF39 !
The formula in AF looks for a tie & if one is found does the following:
- checks games played in M column to see if its the same for both tied players.
- if the same number, then it puts the total points in column K at the end of the original tied number
- if not the same number, then it puts a 00 at the end.
This is the formula in AF12 is as follows:
Code:
=IF(M12<=11,"",AE12*100+IF(AND(SUMPRODUCT(--($AE$11:$AE$99=AE12),--($M$11:$M$99=M12))=COUNTIF($AE$11:$AE$99,AE12),COUNTIF($AE$11:$AE$99,AE12)>1),K12,0))In AF12 & AF13 - works perfectly. games played was the same number so it took the scores of 61 & 57 & applied it to the end breaking the tie.
In AF38 & AF39 - even thou the games played are the same number its putting a 00 instead of 43 & 42 keeping the tie going & giving wrong results.
The player in H39 should be ranked higher than the player in H38 because a score of 43 is higher than 42.
What am I not seeing?
Any help is greatly appreciated.
Thanks,
FreakyGirl