How to calculate best bowling figure (cricket)

[explorerather]

I've provided the template file for your reference.

The concept is to identify the maximum value in column E (wickets) for a given player's statistics. If a player has only one match where they took 3 wickets (for instance, the highest in our example), we would then look at the corresponding value in column D of that same row to determine the number of runs allowed by the player. In this example, it would be 70. Consequently, the results for the best bowling figure would be represented as 70-3.

In another scenario, if a player has taken 3 wickets in two matches, we would seek the minimum value in column D. In the attached picture, the minimum is 32. Therefore, in this case, the results for the best bowling figure would be displayed as 32-3.

For your convenience, I have highlighted on sheet 3 where these results should be displayed.

[DocAElstein]

Thanks, explorerather, for adding a solutions, and welcome to ExcelFox

Just one thing…..

I've provided the template file for your reference……..

I don’t see any file anywhere??




Alan