Cricket Stats Help

jeffreybrown · #10 06-04-2016, 05:08 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Print Stats Office 2010	bolstad2006	Word	5	04-26-2011 09:53 PM