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