Cricket Database

Mudassardp

New Member
Joined
Mar 18, 2019
Messages
3
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.

ABCDEFGHIG

<tbody>
</tbody>

best match1 match2 match3 match4

<tbody>
</tbody>
RunWktRunWktRunWktRunWkt
15 032001300315031202

<tbody>
</tbody>




 

Some videos you may like

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
Joined
Oct 20, 2009
Messages
8,110
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Mar 18, 2019
Messages
3
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.
 

Watch MrExcel Video

Forum statistics

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

This Week's Hot Topics

Top