How to calculate best bowling figure (cricket)

[ahmedleo414]

Thanks for you response Alan

I have attached the template file that I made.

Here is the idea, basically I would find the max value in column E (wickets) for a given players stats, if a player only has one match where he had 3 (in our example case this would be the highest), then we would look at the column D in the same row and get the number of runs allowed by that player (in our example it would be 70) so the results of his best bowling figure would read 70-3

If in another example (such as that in the picture I attached), the person has taken 3 wickets in two matches, in that case we would look for the Min value in column D and in that example it would be 32, so in that case the results of his best bowling figure would read 32-3

I have highlighted, on sheet 3, where the results would be displayed.

...

As for my knowledge in Marco coding (VBA), I have done some very very basic coding for my work, but it was mostly examples I found online of people that had done the same and just modified it for my own use.

If you are able to guide me I can give it a try myself, rather than you writing the code for me. If I can get to update automatically each time a new line is added that would be a bonus.