Cricket Database

[Mudassardp]

Hello Everyone,
I am making a cricket database for a team having a problem with grabbing the best bowling figures from data.
see below example.

in cell B4 should be the player took the maximum wickets in all matches which are 3 wickets in match3 by giving away only 15 Runs.
so in A4 value should be 15 from Match 3. because these are the best Figures of his performances.
please help me with this problem.
thanks.

A

B

C

D

E

F

G

H

I

G

<tbody>
</tbody>

best

match1

match2

match3

match4

<tbody>
</tbody>

		Run	Wkt	Run	Wkt	Run	Wkt	Run	Wkt
15	03	20	01	30	03	15	03	12	02

<tbody>
</tbody>

 

[steve the fish]

Which excel version? If a recent one then maybe in B3:

=MAXIFS($C$3:$J$3,$C$2:$J$2,"Wkt")

In A3:

=MINIFS($C$3:$J$3,$D$3:$K$3,B3)

 

[Mudassardp]

Thanks Steve.
I am using office 2007 the formula i am using for max is {=MAX(IF($C$2:$J$2=$D$2,C3:J3))} that gives me Maximum value in column range which have title wkt.
however what i am looking for is to get value of Runs in same match. for example in above table the best figures are 15-03 so i want to get those values in A3=G15(match3) and B3=H3 in same match. so whatever is maximum wkt the column Run beside it should go in A3.
hope somebody can help me with this.
thanks.

 

[steve the fish]

=min(if($c$3:$j$3=b3,$b$3:$i$3))