i am doing cricket statistics for my team. I want to be able to show the best bowling figures. I have wickets in one column and runs in the next column. best bowling figures is the one with the most wickets with the least amount of runs. i am able to find the most wickets by using the MAX function. i then used VLOOKUP to get the corresponding runs. My problem is that if i have more than one occasion with the most wickets, i need to match it to the one with the least amount of runs conceeded.
Any help would be much appreciated
Any help would be much appreciated