A couple more cricket questions - hopefully my last. These are similar to previous requests but different enough that I can't tweak them myself.
HIGH SCORE
I have a list of scores like this: 85*(75) or 85(75). The 85 is the score, the asterisk denotes a 'not out' score, and the 75 is the number of balls faced. I need a formula that selects the best score from the list with these criteria in mind:
85(x) > 84(x) [Higher scores are better.]
85*(x) > 85(x) ['Not out' scores are better than equal scores that aren't 'not out'.)
85(75) > 85(76) [If both conditions above are equal, the score with the lowest amount of balls faced is better.]
BEST BOWLING
I have a list of figures like this: 3/35(8). The 3 is the number of wickets taken, the 35 is the number of runs conceded, and the 8 is the number of overs bowled. I need a formula that selects the best figures with these criteria in mind:
3/35(x) > 2/15(x) [Higher number of wickets is better.]
3/35(x) > 3/36(x) [If wickets are equal, lower conceded runs are better.]
The value in brackets isn't really relevant, although it should still be displayed with the best figures. If I had to decide, I'd say that a higher value in the brackets should break a tie between best figures, but it's not required; displaying either would be fine.
I've attached a file with test data, more information and expected results. Any help from the resident geniuses would be appreciated. Thanks guys.
Bookmarks