Spreadsheet: 98430d1297333939-excel-2007-creating-a-formula-that-addresses-three-separate-columns-career-olsen-md
Sheet: Matches

Match No. | Season | Start Date | Type | Opponents | Ground | Toss | Captain | Capt / W/K | Result
1 | 2001/02 | 2002-03-16 00:00:00 | Two-Day | Victoria | Chukker Road Sports Complex, Lansdowne | WF | AW Saunders |  | Won chasing target
2 | 2001/02 | 2002-03-23 00:00:00 | Two-Day | Claremont | [NAME] Oval, Plumstead | LF | AW Saunders |  | [NAME]
3 | 2002/03 | 2002-10-19 00:00:00 | Two-Day | Western Province CC | The Vineyard, Newlands | WF | AW Saunders |  | Lost by an innings
4 | 2002/03 | 2002-10-26 00:00:00 | Two-Day | Victoria | [NAME] Oval, Plumstead | WB | AW Saunders |  | Lost defending target
5 | 2002/03 | 2002-11-09 00:00:00 | Two-Day | Langa | [NAME] Oval, Plumstead | WB | AW Saunders |  | Won defending target
6 | 2002/03 | 2002-11-23 00:00:00 | Two-Day | Pinelands | [NAME] Oval, Plumstead | LB | [NAME] |  | Lost defending target
7 | 2002/03 | 2002-12-14 00:00:00 | Two-Day | Montrose | [NAME], Rylands | WF | AW Saunders |  | [NAME]
8 | 2003/04 | 2004-03-20 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | LB | [NAME] |  | Lost defending target
9 | 2005/06 | 2005-10-01 00:00:00 | Ltd Overs | Western Province CC | The Vineyard, Newlands | WF | [NAME] |  | Won chasing target
10 | 2005/06 | 2006-02-26 00:00:00 | AMA20-20 | Claremont | [NAME], Durbanville | LF | [NAME] |  | Won chasing target
11 | 2006/07 | 2006-10-07 00:00:00 | Two-Day | Durbanville | [NAME] Oval, Plumstead | LB | [NAME] |  | Won defending target
12 | 2006/07 | 2006-10-21 00:00:00 | Two-Day | Victoria | Chukker Road Sports Complex, Lansdowne | LB | [NAME] |  | [NAME]
13 | 2006/07 | 2006-11-04 00:00:00 | Two-Day | Almar | [NAME], [NAME] | LB | [NAME] |  | Won defending target
14 | 2006/07 | 2006-11-11 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | LF | [NAME] |  | Lost chasing target
15 | 2006/07 | 2006-11-12 00:00:00 | Ltd Overs | Victoria | [NAME] Oval, Plumstead | WB | [NAME] |  | Won defending target
16 | 2006/07 | 2006-11-25 00:00:00 | Two-Day | Pinelands | [NAME] Oval, Plumstead | LB | [NAME] |  | Won chasing target
17 | 2006/07 | 2007-01-20 00:00:00 | Two-Day | Claremont | [NAME] Oval, Plumstead | LF | [NAME] |  | [NAME]
18 | 2006/07 | 2007-02-04 00:00:00 | Two-Day | University of Cape Town | [NAME] Oval, Plumstead | LB | [NAME] |  | Won defending target
19 | 2006/07 | 2007-02-24 00:00:00 | Two-Day | Montrose | [NAME] Oval, Plumstead | WB | [NAME] |  | [NAME]
20 | 2006/07 | 2007-03-10 00:00:00 | Two-Day | Western Province CC | [NAME], [NAME] | WB | [NAME] |  | Lost defending target
21 | 2006/07 | 2007-03-24 00:00:00 | Two-Day | Tygerberg | Florida Park, Ravensmead | WF | [NAME] |  | Won chasing target
22 | 2007/08 | 2007-10-06 00:00:00 | Ltd Overs | Durbanville | [NAME], Durbanville | WF | [NAME] |  | Won chasing target
23 | 2007/08 | 2007-10-20 00:00:00 | Two-Day | Victoria | [NAME] Oval, Plumstead | WF | [NAME] |  | Won chasing target
24 | 2007/08 | 2007-11-03 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | LB | [NAME] |  | [NAME]
25 | 2007/08 | 2007-11-17 00:00:00 | Two-Day | Durbanville | [NAME], Durbanville | LB | [NAME] |  | [NAME]
26 | 2007/08 | 2007-11-18 00:00:00 | Two-Day | Claremont | [NAME], [NAME] | LF | [NAME] |  | [NAME]
27 | 2007/08 | 2007-12-15 00:00:00 | Two-Day | Pinelands | Pinelands Oval, Pinelands | LB | [NAME] |  | [NAME]
28 | 2007/08 | 2008-01-05 00:00:00 | Ltd Overs | Rondebosch | [NAME] Oval, Plumstead | LB | [NAME] |  | Won defending target
29 | 2007/08 | 2008-01-12 00:00:00 | Two-Day | Western Province CC | [NAME] Oval, Plumstead | LF | [NAME] |  | [NAME]
30 | 2007/08 | 2008-02-09 00:00:00 | Two-Day | University of Cape Town | UCT Oval, Groote Schuur | WF | [NAME] |  | Lost defending target
31 | 2007/08 | 2008-02-23 00:00:00 | Two-Day | University of the Western Cape | [NAME] Oval, Plumstead | LB | [NAME] |  | Lost defending target
32 | 2007/08 | 2008-03-09 00:00:00 | Ltd Overs | Primrose | Rosmead Sports Grounds, Kenilworth | LF | [NAME] |  | Won chasing target
33 | 2007/08 | 2008-03-28 00:00:00 | Ltd Overs | University of the Western Cape | Sahara Park Newlands | LF | [NAME] |  | Lost chasing target
34 | 2007/08 | 2008-03-29 00:00:00 | Two-Day | Rondebosch | [NAME] Oval, Plumstead | LF | [NAME] |  | Lost chasing target
35 | 2008/09 | 2008-10-11 00:00:00 | Ltd Overs | Claremont | [NAME] Oval, Plumstead | WF | JS Holgate |  | Lost chasing target
36 | 2008/09 | 2008-11-01 00:00:00 | Two-Day | Northerns-Goodwood | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target
37 | 2008/09 | 2008-11-15 00:00:00 | Two-Day | [NAME] | [NAME], Ruyterwacht | LF | JS Holgate |  | [NAME]
38 | 2008/09 | 2008-11-29 00:00:00 | Ltd Overs | Tygerberg | [NAME] Oval, Plumstead | WF | [NAME] |  | Won chasing target
39 | 2008/09 | 2008-12-13 00:00:00 | Two-Day | Old Mutual | Mutual Park, Pinelands | LB | JS Holgate |  | Lost defending target
40 | 2008/09 | 2009-01-10 00:00:00 | Two-Day | Somerset West | [NAME] Oval, Plumstead | LF | JS Holgate |  | Won by an innings
41 | 2008/09 | 2009-01-11 00:00:00 | Ltd Overs | Western Province CC | [NAME], [NAME] | LF | JS Holgate |  | Lost chasing target
42 | 2008/09 | 2009-01-24 00:00:00 | Two-Day | Primrose | Rosmead Sports Grounds, Kenilworth | LF | JS Holgate |  | Won chasing target
43 | 2008/09 | 2009-02-07 00:00:00 | Two-Day | Kuils River | Sarepta Sports Complex, Kuils River | WB | [NAME] |  | Lost defending target
44 | 2008/09 | 2009-02-08 00:00:00 | Ltd Overs | Kuils River | [NAME] Oval, Plumstead | WB | [NAME] |  | Won defending target
45 | 2008/09 | 2009-02-21 00:00:00 | Two-Day | Pinelands | [NAME] Oval, Plumstead | LB | JS Holgate |  | Lost defending target
46 | 2008/09 | 2009-03-07 00:00:00 | Two-Day | Tygerberg | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target
47 | 2008/09 | 2009-03-21 00:00:00 | AMA20-20 | Old Mutual | Edgemead Cricket Club, Edgemead | LF | [NAME] |  | Lost chasing target
48 | 2008/09 | 2009-03-21 00:00:00 | AMA20-20 | Primrose | Edgemead Cricket Club, Edgemead | LF | [NAME] |  | Won chasing target
49 | 2008/09 | 2009-03-28 00:00:00 | AMA20-20 | Northerns-Goodwood | [NAME], Somerset West | WF | [NAME] |  | Lost chasing target
50 | 2008/09 | 2009-03-29 00:00:00 | AMA20-20 | Pinelands | [NAME], [NAME] | WB | [NAME] |  | Won defending target
51 | 2009/10 | 2009-10-10 00:00:00 | Ltd Overs | St Augustines | [NAME], Elfindale | LF | JS Holgate |  | Won chasing target
52 | 2009/10 | 2009-10-17 00:00:00 | Two-Day | Primrose | [NAME] Oval, Plumstead | WF | JS Holgate |  | Lost chasing target
53 | 2009/10 | 2009-10-31 00:00:00 | Two-Day | [NAME] | [NAME] Oval, Plumstead | WB | JS Holgate |  | Lost defending target
54 | 2009/10 | 2009-11-14 00:00:00 | Two-Day | Almar | [NAME], [NAME] | WF | JS Holgate |  | Won chasing target
55 | 2009/10 | 2009-11-28 00:00:00 | Ltd Overs | Victoria | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target
56 | 2009/10 | 2009-12-05 00:00:00 | Two-Day | Victoria | [NAME] Oval, Plumstead | LF | JS Holgate |  | Won chasing target
57 | 2009/10 | 2009-12-16 00:00:00 | Two-Day | Pinelands | Pinelands Oval, Pinelands | LF | JS Holgate |  | Won chasing target
58 | 2009/10 | 2010-01-09 00:00:00 | Two-Day | Montrose | The Vineyard, Newlands | WF | JS Holgate |  | Won chasing target
59 | 2009/10 | 2010-01-23 00:00:00 | AMA20-20 | [NAME] | PP Smit Sports Complex, Bellville | WF | JS Holgate |  | Won chasing target
60 | 2009/10 | 2010-01-23 00:00:00 | AMA20-20 | Tygerberg | PP Smit Sports Complex, Bellville | WB | JS Holgate |  | Won defending target
61 | 2009/10 | 2010-01-30 00:00:00 | AMA20-20 | Pinelands | Edgemead Cricket Club, Edgemead | WB | JS Holgate |  | Won defending target
62 | 2009/10 | 2010-01-31 00:00:00 | AMA20-20 | Primrose | [NAME] Oval, Plumstead | LB | JS Holgate |  | Lost chasing target
63 | 2009/10 | 2010-02-06 00:00:00 | Two-Day | Northerns-Goodwood | Northerns-Goodwood CC Oval, Goodwood | LB | JS Holgate |  | Won defending target
64 | 2009/10 | 2010-02-20 00:00:00 | Ltd Overs | University of the Western Cape | Western Cape University Oval, Bellville South | LB | JS Holgate |  | Won defending target
65 | 2009/10 | 2010-03-06 00:00:00 | Two-Day | Tygerberg | [NAME] Oval, Plumstead | WB | JS Holgate |  | Won defending target
66 | 2009/10 | 2010-03-07 00:00:00 | Ltd Overs | Durbanville | [NAME], Durbanville | WB | JS Holgate |  | Won defending target
67 | 2009/10 | 2010-03-20 00:00:00 | Two-Day | Kuils River | [NAME] Oval, Plumstead | LB | JS Holgate |  | Won defending target
68 | 2009/10 | 2010-03-31 00:00:00 | Ltd Overs | Old Mutual | Sahara Park Newlands | WB | JS Holgate |  | Lost defending target
69 | 2010/11 | 2010-10-02 00:00:00 | AMA20-20 | Tygerberg | [NAME], [NAME] | WF | GA Dods |  | Lost chasing target
70 | 2010/11 | 2010-10-09 00:00:00 | AMA20-20 | Green Point-CPUT | Chukker Road Sports Complex, Lansdowne | WB | GA Dods |  | Won defending target
71 | 2010/11 | 2010-10-09 00:00:00 | AMA20-20 | St Augustines | Chukker Road Sports Complex, Lansdowne | WB | GA Dods |  | Won defending target
72 | 2010/11 | 2010-10-10 00:00:00 | AMA20-20 | Victoria | [NAME], Green Point | WB | GA Dods |  | No Result / Abandoned
73 | 2010/11 | 2010-10-16 00:00:00 | Two-Day | Victoria | Chukker Road Sports Complex, Lansdowne | LF | GA Dods |  | Won chasing target
74 | 2010/11 | 2010-10-30 00:00:00 | Two-Day | Primrose | Rosmead Sports Grounds, Kenilworth | WB | GA Dods |  | Lost defending target
75 | 2010/11 | 2010-11-13 00:00:00 | Two-Day | Tygerberg | [NAME] Oval, Plumstead | LF | GA Dods |  | [NAME]
76 | 2010/11 | 2010-11-27 00:00:00 | Two-Day | Montrose | [NAME] Oval, Plumstead | WF | GA Dods |  | Lost chasing target
77 | 2010/11 | 2010-12-11 00:00:00 | Ltd Overs | Northerns-Goodwood | Northerns-Goodwood CC Oval, Goodwood | LF | GA Dods |  | Won chasing target
78 | 2010/11 | 2010-12-16 00:00:00 | Ltd Overs | St Augustines | [NAME] Oval, Plumstead | LB | GA Dods |  | Lost defending target
79 | 2010/11 | 2010-12-18 00:00:00 | Ltd Overs | Bellville | PP Smit Sports Complex, Bellville | LF | GA Dods |  | Lost chasing target
80 | 2010/11 | 2011-01-22 00:00:00 | Two-Day | Almar | [NAME] Oval, Plumstead | LB | GA Dods |  | Won by an innings
81 | 2010/11 | 2011-02-05 00:00:00 | Two-Day | [NAME] | [NAME], Ruyterwacht | LB | GA Dods
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
 | Two-Day
 | Ltd Overs
 | AMA20-20
 | Almar
 | Bellville
 | [NAME]
 | Brooklyn-Telkom
 | Claremont
 | Durbanville
 | Fish Hoek
 | [NAME]
 | Green Point-CPUT
 | Kuils River
 | Langa
 | Montrose
 | Northerns-Goodwood
 | Oakdale
 | Old Mutual
 | Pinelands
 | Primrose
 | Rondebosch
 | Somerset West
 | St Augustines
 | [NAME]
 | Tygerberg
 | United
 | University of Cape Town
 | University of the Western Cape
 | Victoria
 | Western Province CC
 | [NAME], Elfindale
 | Bishop Lavis Cricket Club, [NAME]
 | [NAME] Oval, Plumstead
 | Chukker Road Sports Complex, Lansdowne
 | [NAME], [NAME]
 | [NAME], [NAME]
 | [NAME], Durbanville
 | Edgemead Cricket Club, Edgemead
 | Florida Park, Ravensmead
 | Green Point Track, Green Point
 | [NAME], Wynberg Boys' High School
 | [NAME], Langa
 | [NAME], Rylands
 | Mutual Park, Pinelands
 | Northerns-Goodwood CC Oval, Goodwood
 | Pinelands Oval, Pinelands
 | PP Smit Sports Complex, Bellville
 | [NAME], Somerset West
 | [NAME], [NAME]
 | Rosmead Sports Grounds, Kenilworth
 | [NAME], Rondebosch
 | Sahara Park Newlands
 | Sarepta Sports Complex, Kuils River
 | Silverglades, Fish Hoek
 | [NAME], Ruyterwacht
 | [NAME], Green Point
 | The Vineyard, Newlands
 | UCT Oval, Groote Schuur
 | [NAME], [NAME]
 | Western Cape University Oval, Bellville South
 | Wynberg Sports Club, Wynberg
 | WB
 | WF
 | LB
 | LF
 | Won by an innings
 | Won chasing target
 | Won defending target
 | Tie
 | [NAME]
 | No Result / Abandoned
 | Lost by an innings
 | Lost chasing target
 | Lost defending target