Hoping someone can help me!
I've worked myself out a cricket scoring spreadsheet, which works absolutely fine - trying to sort out a summary page, where you see (funnily enough!) a summary of the game info.
As part of this, I'd like to be able to use the information on the following table:
Bowler Wkts Runs Amir 0 41 Irfan 1 46 Sami 2 23 Imad 0 26 Afridi 2 40
to select the best bowler for the summary page.
I have an understanding of writing an INDEX...MATCH... statement, but am having trouble with this, because I would like to select the bowler name where the wickets value is the most, but the runs value is the lowest amongst the bowlers taking that number of wickets - in this case, Sami.
I imagine I'll be trying something using INDEX, MATCH, MAX and MIN (with some IFs thrown in!), but really don't know where to start.
Any help would be gratefully received!