Quote Originally Posted by kasablur View Post
...I tried the best bowling formulas (and cnahged the Z's to U's) and it cam eup with n/a for each player. Have I done something wrong?
The best bowling formula on Stats sheet utilised the BB formula on Inputs sheet. In your most recent version you have adapted your Inputs sheet and removed the BB formula (previously column Z) - hence the n/a returns.

Adapt your latest version as follows:

Inputs
AA1:
BB

AA2:
=IF(Q2=0,"",U2+(1-MAX((0&T2)+0,0.1)/1000))
copied down to AA387
Then

Stats
P16:
=MAX(IF(Inputs!$B$2:$B$387=$A16,Inputs!$AA$2:$AA$387))
confirmed with CTRL + SHIFT + ENTER (Enter alone will not suffice)
copied down to P27
If the array is set correctly the above will appear encased within { } [these can not be typed]
If the above have been added correctly the Stats results will be as follows:

2-10
3-31
1-10
0-15
0-40
0-31
n/a
5-27
0-8
0-19
1-1
0-0