How to calculate best bowling figure (cricket)

[DocAElstein]

Hello ahmedleo414
Welcome to ExcelFox

I personally would not know how to do this with a formula. It may be possible, but could be quite difficult. I am not too good at formulas

Using Excel VBA, there are probably lots of different ways to do it. There are also probably infinite ways to give the output.

It would be easier for us to give you some ideas if you could give us a sample file, instead of an image.

Maybe you could tell us a bit more, as it is not easy to know what help you actually need. Tell us a bit about yourself: What is your knowledge level of Excel and VBA? What/ where do you want the output.
If an Excel VBA solution is acceptable to you, then what should trigger the macro coding? Should it start automatically when new data is added, or do you want to start the macro yourself, ( if you know how to). Do you want a button somewhere to start the macro coding.

---

In the absence of a file or more info from you, I can give just some general thoughts, for now.
I would probably determine the maximum value in column E ( Wickets ), then look at all the values in column D ( Runs ) in the rows with the maximum column E values, and take the smallest column D from those row values

That is a simple logic, and a simple macro coding could be written to do that

I am going away off line now. I will take another look in tomorrow

Alan