Appearances and goals over 100 years

[ScjR]

These returns show Rotherham's highest goalscorers and appearances by competition, they have been filtered in a pivot table to return the highest value (top 10 or top 25). I've never fully understood the results they return (although I understand the logic of what pivot tables do when settings are set to return the top values) so I've put the settings I use in each table.


All Competitions Goals (Top 25)
1) Jack Shaw 147 (Doncacter Rovers 11, Accrington Stanley 9, Carlisle United 8, New Brighton 7, Crewe Alexandra 7)
2) Gladstone Guest 136 (York City 8, Tranmere Rovers 8, Lincoln City 8, Oldham Athletic 7, Darlington 6)
3) Jack Grainger 127 (Bristol City 6, Nottingham Forest 6, Doncaster Rovers 6, Oldham Athletic 5, Bury 5, Blackburn Rovers 5, Fulham 5)
4) Wally Ardron 120 (Crewe Alexandra 10, Carlisle United 9, Barnsley 8, Wrexham 7, Oldham Athletic 7, Hartlepool United 7, Accrington Stanley 7)
5) Trevor Phillips 94
6) Shaun Goater 86
7) Richard Finney 86
8) Albert Bennett 72
9) Ken Houghton 68
10) Alan Crawford 68
11) Bobby Williamson 64
12) Alan Kirkman 63
13) Rowland Bastow 62
14) Arnold Bramham 62
15) Michael Smith 61
16) Ronnie Burke 61
17) Adam Le Fondre 58
18) Ronnie Moore 57
19) Dave Gwyther 57
20) John Galley 56
21) Mick Gooding 54
22) Ian Wilson 49
23) Mark Robins 49
24) Shaun Goodwin 48
25) Joe Scott 48

Football League Appearances (Top 10)
1) Danny Williams 462
2) Paul Hurst 435
3) Jack Selkirk 427
4) John Breckin 409
5) Gerry Forrest 391
6) Gladstone Guest 358
7) Jack Grainger 352
8) John Green 335
9) Norman Noble 326
10) Trevor Phillips 322
Football League Goals (Top 25)
1) Gladstone Guest 129
2) Jack Shaw 123
3) Jack Grainger 112
4) Wally Ardron 99
5) Trevor Phillips 80
6) Shaun Goater 70
7) Richard Finney 68
8) Albert Bennett 64
9) Rowland Bastow 60
10) Ken Houghton 58
11) Alan Kirkman 57
12) Ronnie Burke 56
13) Adam Le Fondre 54
14) Arnold Bramham 54
15) Michael Smith 52
16) Ronnie Moore 52
17) Alan Crawford 49
18) Bobby Williamson 48
19) John Galley 47
20) Ian Wilson 45
21) Dave Gwyther 45
22) Mark Robins 44
23) Albert Parkin 44
24) Ernest Smith 44
25) Vic Wright 43

FA Cup Appearances (Top 10)
1) Danny Williams 39
2) Jack Selkirk 29
3) Trevor Swift 28
4) Gerry Forrest 28
5) Paul Hurst 27
6) John Breckin 27
7) David Bentley 26
8) Jack Shaw 24
9) James Turner 22
10) Richard Finney 22
11) Trevor Womble 22
12) John Green 22
13) Paul Stancliffe 22
FA Cup Goals (Top 10)
1) Jack Shaw 18
2) Alan Crawford 10
3) Jack Grainger 8
4) Wally Ardron 7
5) Shaun Goater 7
6) Carl Gilbert 6
7) Trevor Phillips 6
8) Darren Garner 6
9) Dave Gwyther 6
10) Richard Finney 5
11) John Fantham 5
12) Fred Lievesley 5

League Cup Appearances (Top 10)
1) Gerry Forrest 40
2) John Breckin 31
3) Shaun Goodwin 27
4) John Green 27
5) Mick Gooding 27
6) Nigel Johnson 26
7) Peter Madden 25
8) Richard Finney 24
9) Mark Rhodes 23
10) Roy Lambert 23
League Cup Goals (Top 10)
1) Richard Finney 9
2) Alan Crawford 8
3) Ken Houghton 8
4) Mick Gooding 6
5) Bobby Williamson 5
6) Brian Tiler 5
7) Trevor Phillips 5
8) Frank Casper 5
9) Don Weston 5
10) Rodney Fern 5
11) John Galley 5
12) Kevin Kilmore 5

FLT Appearances (Top 10)
1) Shaun Goodwin 22
2) Shaun Goater 20
3) Paul Hurst 18
4) Des Hazel 18
5) Nigel Johnson 14
6) Kelham O'Hanlon 14
7) Neil Richardson 13
8) Hakeem Odoffin 12
9) Trevor Berry 12
10) Ian Breckin 11
11) John Dungworth 11
12) Jack Holmes 11
13) Phil Crosby 11 0 11
FLT Goals (Top 10)
1) Des Hazel 6
2) Michael Smith 5
3) Shaun Goater 5
4) Shaun Goodwin 4
5) Kieran Sadlier 4
6) Nigel Jemson 4
7) Jordan Hugill 4
8) Tony Grealish 3
9) Will Grigg 3
10) Josh Benson 3
11) Freddie Ladapo 3
12) Tony Cunningham 3