display name along with score

[simisingh3]

Hi i am new to excel.... I am trying to create a formula to display the name and score of the highest scorer of the tournament, best Eco rate, Best Strike Rate, Name of bowlers with more than 5 wickets, Most 100's,50's, 4's and 6's but i dont know how to use the functions... can some one please help me...

I have calculated the Scores but dont know how to display the name along... Please Help

[adaws]

your sheet has no data in it, except formulaes, can u have some data populated for better solutions?

[simisingh3]

I have populated the data

[micope21]

Hi

Give me 24 hour. You will have file with Name and best 100s and 50s

[micope21]

Here the file

[simisingh3]

thank you

[simisingh3]

there is some problem with the Economy rate formula for the bowling sheet..

[simisingh3]

also the Strike rate formula

[micope21]

Explain why problem with Economy rate and Strike rate in bowling sheet?

Are you looking for Percentage within 100% or over 100%

[simisingh3]

it is not calculating correctly.... economy rate is too high and strike rate too low

[simisingh3]

within 100%

Strike Rate shud be runs per 100 balls

and Economy rate runs per 6 balls

[simisingh3]

It's alright i figured it out

[micope21]

Ok No worry any problem let me know cheer

[simisingh3]

hi

u did not send me the formulas for most 50's and most 100's

simi

[simisingh3]

Hi,

Could you please tell me how i could calculate the number of innings played.

Thank you