Philip Rogers
New Member
- Joined
- Jan 19, 2004
- Messages
- 23
I am trying to find a way to consolidate the data that is on three different worksheets. The column headings are the same BUT the information in Col A Row 1 to .... is different. The data in the columns to the right is determined by the name in col A.
Bowling.htm | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Statistics | |||||||||||||
2 | Club:FennerCricketClub | |||||||||||||
3 | MatchType:EYCAPremierLeague | Season:2005 | ||||||||||||
4 | Player:All | |||||||||||||
5 | Name | M | Overs | Mdns | Runs | Wkts | Avg | Econ. | S/r | 5wh | Best | %Total | ||
6 | AHussain | 2 | 5 | 1 | 30 | 1 | 30.00 | 6.00 | 30.00 | 0 | 1-30 | 0.68% | ||
7 | GPowley | 7 | 15 | 2 | 70 | 2 | 35.00 | 4.67 | 45.00 | 0 | 1-21 | 1.36% | ||
8 | JLatus | 3 | 16 | 3 | 54 | 2 | 27.00 | 3.38 | 48.00 | 0 | 1-20 | 1.36% | ||
9 | JMPark | 17 | 190.3 | 49 | 456 | 41 | 11.12 | 2.39 | 27.88 | 2 | 6-49 | 27.89% | ||
10 | JPSowter | 17 | 103 | 16 | 357 | 19 | 18.79 | 3.47 | 32.53 | 1 | 7-88 | 12.93% | ||
11 | LLaybourne | 12 | 62 | 11 | 221 | 5 | 44.20 | 3.56 | 74.40 | 0 | 3-60 | 3.40% | ||
12 | MArundell | 9 | 14 | 2 | 54 | 8 | 6.75 | 3.86 | 10.50 | 0 | 4-10 | 5.44% | ||
13 | PFuller | 14 | 77 | 10 | 268 | 12 | 22.33 | 3.48 | 38.50 | 0 | 4-76 | 8.16% | ||
14 | PScrowston | 18 | 25 | 4 | 81 | 5 | 16.20 | 3.24 | 30.00 | 0 | 3-38 | 3.40% | ||
15 | RBarker | 10 | 58 | 10 | 202 | 14 | 14.43 | 3.48 | 24.86 | 0 | 5-22 | 9.52% | ||
16 | SHewitt | 19 | 175.1 | 44 | 467 | 34 | 13.74 | 2.67 | 30.91 | 1 | 3-11 | 23.13% | ||
17 | SLatus | 1 | 3.5 | 0 | 11 | 4 | 2.75 | 2.87 | 5.75 | 0 | 4-11 | 2.72% | ||
2005 Bowling |