Thread: [Solved] Cricket Stats Help
View Single Post
 
Old 06-04-2016, 05:08 AM
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

With the setup I have in the last attached workbook, can you sort column F (Largest to Smallest) and then column G (Smallest to Largest)?

If you do that then everything will run 1, 2, 3, 4, 5 etc down the line.

Code:
      ---F--- -G-- --H--
  3   Wickets Runs Rank
  4      6     5     1  
  5      4     13    2  
  6      3     6     3  
  7      2     7     4  
  8      2     15    5
H4 copied down -- >> =RANK(F4,$F$4:$F$18,0)+COUNTIF($F$4:F4,F4)-1

And actually you wouldn't even need column H as again, every thing is in order.

Code:
       -----D----- -E--
  17    Tom White  6-5 
  18   Matt Lovell 4-13
  19    Ian Giles  3-6 
  20   Robin Wood  2-7 
  21   Nick Causer 2-15
E17 copied down -- >> ='Bowling Stats'!$F4&"-"&'Bowling Stats'!$G4
D17 copied down -- >> ='Bowling Stats'!$A4
Reply With Quote