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?
|