# Cricket Database

#### Mudassardp

##### New Member
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>

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### steve the fish

##### Well-known Member
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

##### New Member
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

##### Well-known Member
=min(if(\$c\$3:\$j\$3=b3,\$b\$3:\$i\$3))

Replies
0
Views
296
Replies
1
Views
682
Replies
0
Views
699
Replies
5
Views
593
Replies
1
Views
356

Threads
1,109,331
Messages
5,528,052
Members
409,800
Latest member
camronmartin