Thread: [Solved] Cricket Stats Help
View Single Post
 
Old 05-30-2016, 04:37 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Hello & Welcome to the Forum,

Well up front I'll say I know nothing about cricket, but maybe I can help with some formulas.

Q1: How about on the Bowling Stats tab, use a unique rank in column L.
=RANK(K4,$K$4:$K$18,0)+COUNTIF($K$4:K4,K4)-1

Q2: I see you have 6-5 as the best figure followed by 4-13. Is it as simple as the 6-5 is 6 wins and five loses. If that is so, maybe do another unique count on the left part of 6-5?
Reply With Quote