Formula To Get Best Bowling Stats From Wickets Taken and Runs Conceded [Cricket Bowling]

[msiyab]

This will do it (use as an array formula)

=MAX(B15:K15)&"/"&MIN(IF(B15:K15=MAX(B15:K15),B14:K14))

The above formula does not give the desired result. The "Wickets" part is getting calculated, but the "Runs Given" part is giving out the result as 0.


Microsoft_Excel_XRP_Stats.xlsx_000098.jpg

In the above picture, the best stats is where "Runs Given" is 42 & "Wickets" is 5. The formula provided earlier is giving the result as 5/0.

Basically, the formula should first look for the highest number of wickets, and then the lowest runs given whenever the player has taken that number of wickets.
For Example, in the above picture, there are 2 matches where the player has taken 5 wickets, but has given 42 runs in one match & 43 runs in another. Therefore, the formula should give out the result as 5/42.

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=bRd4mJglWiM&lc=UgxRmh2gFhpmHNnPemR4AaABAg
https://eileenslounge.com/viewtopic.php?p=316705#p316705
https://eileenslounge.com/viewtopic.php?p=316704#p316704
https://eileenslounge.com/viewtopic.php?f=27&t=40919&p=316597#p316597
https://eileenslounge.com/viewtopic.php?p=316412#p316412
https://eileenslounge.com/viewtopic.php?p=316254#p316254
https://eileenslounge.com/viewtopic.php?p=316280#p316280
https://eileenslounge.com/viewtopic.php?p=315915#p315915
https://eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315744#p315744
https://www.eileenslounge.com/viewtopic.php?p=315512#p315512
https://eileenslounge.com/viewtopic.php?p=315680#p315680
https://eileenslounge.com/viewtopic.php?p=315743#p315743
https://www.eileenslounge.com/viewtopic.php?p=315326#p315326
https://www.eileenslounge.com/viewtopic.php?f=30&t=40752
https://eileenslounge.com/viewtopic.php?p=314950#p314950
https://www.eileenslounge.com/viewtopic.php?p=314940#p314940
https://www.eileenslounge.com/viewtopic.php?p=314926#p314926
https://www.eileenslounge.com/viewtopic.php?p=314920#p314920
https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
https://www.eileenslounge.com/viewtopic.php?f=21&t=40701&p=314836#p314836
https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314621#p314621
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA