Spreadsheet: 754641d1636399826-creating-a-formula-to-do-a-teammate-count-team-mate-example_gw_reva
Sheet: Sheet1

Premiership Teams |  |  |  |  | TEAMMATE COUNT |  | Expected | Geoff | [NAME]
2016/17 | 1st XI | M Hayden |  |  | J Langer | M Hayden
2016/17 |  | J Langer |  |  | J Langer | R Ponting
2016/17 |  | R Ponting |  |  | M Hayden | R Ponting
2016/17 |  | M Waugh |  |  | D Martyn | M Hayden
2016/17 |  | M Clarke |  |  | D Martyn | J Langer
2016/17 |  | S Waugh |  |  | D Martyn | R Ponting
2016/17 |  | A Gilchrist |  |  | D Martyn | M Johnson
2016/17 |  | B [NAME] |  |  | J Langer | M Johnson
2016/17 |  | J Gillespie |  |  | M Hayden | M Johnson
2016/17 |  | S Warne |  |  | M Johnson | R Ponting
2016/17 |  | G McGrath |  |  | A Border | M Hayden
2017/18 | 1st XI | M Hayden |  |  | A Border | J Langer
2017/18 |  | J Langer |  |  | A Border | R Ponting
2017/18 |  | R Ponting |  |  | A Border | D Martyn
2017/18 |  | A Border |  |  | A Border | S Marsh
2017/18 |  | D Martyn |  |  | A Border | M Marsh
2017/18 |  | S Marsh |  |  | A Border | I Healy
2017/18 |  | M Marsh |  |  | A Border | D Fleming
2017/18 |  | I Healy |  |  | A Border | S Macgill
2017/18 |  | D Fleming |  |  | A Border | M Johnson
2017/18 |  | S Macgill |  |  | A Gilchrist | M Hayden
2017/18 |  | M Johnson |  |  | A Gilchrist | J Langer
2020/21 | 1st XI | M Hayden |  |  | A Gilchrist | R Ponting
2020/21 |  | J Langer |  |  | A Gilchrist | M Waugh
2020/21 |  | R Ponting |  |  | A Gilchrist | M Clarke
2020/21 |  | S Smith |  |  | A Gilchrist | S Waugh
2020/21 |  | D Martyn |  |  | A Gilchrist | B [NAME]
2020/21 |  | D Warner |  |  | A Gilchrist | J Gillespie
2020/21 |  | M Wade |  |  | A Gilchrist | S Warne
2020/21 |  | G Maxwell |  |  | A Gilchrist | G McGrath
2020/21 |  | N Lyon |  |  | B [NAME] | M Hayden
2020/21 |  | M Johnson |  |  | B [NAME] | J Langer
2020/21 |  | M Starc |  |  | B [NAME] | R Ponting
 |  |  |  |  | B [NAME] | M Waugh
 |  |  |  |  | B [NAME] | M Clarke
 |  |  |  |  | B [NAME] | S Waugh
 |  |  |  |  | B [NAME] | J Gillespie
 |  |  |  |  | B [NAME] | S Warne
 |  |  |  |  | B [NAME] | G McGrath
 |  |  |  |  | D Fleming | M Hayden
 |  |  |  |  | D Fleming | J Langer
 |  |  |  |  | D Fleming | R Ponting
 |  |  |  |  | D Fleming | D Martyn
 |  |  |  |  | D Fleming | S Marsh
 |  |  |  |  | D Fleming | M Marsh
 |  |  |  |  | D Fleming | I Healy
 |  |  |  |  | D Fleming | S Macgill
 |  |  |  |  | D Fleming | M Johnson
 |  |  |  |  | D Martyn | S Marsh
 |  |  |  |  | D Martyn | M Marsh
 |  |  |  |  | D Martyn | I Healy
 |  |  |  |  | D Martyn | S Macgill
 |  |  |  |  | D Martyn | S Smith
 |  |  |  |  | D Martyn | D Warner
 |  |  |  |  | D Martyn | M Wade
 |  |  |  |  | D Martyn | G Maxwell
 |  |  |  |  | D Martyn | N Lyon
 |  |  |  |  | D Martyn | M Starc
 |  |  |  |  | D Warner | M Hayden
 |  |  |  |  | D Warner | J Langer
 |  |  |  |  | D Warner | R Ponting
 |  |  |  |  | D Warner | M Johnson
 |  |  |  |  | D Warner | S Smith
 |  |  |  |  | D Warner | M Wade
 |  |  |  |  | D Warner | G Maxwell
 |  |  |  |  | D Warner | N Lyon
 |  |  |  |  | D Warner | M Starc
 |  |  |  |  | G Maxwell | M Hayden
 |  |  |  |  | G Maxwell | J Langer
 |  |  |  |  | G Maxwell | R Ponting
 |  |  |  |  | G Maxwell | M Johnson
 |  |  |  |  | G Maxwell | S Smith
 |  |  |  |  | G Maxwell | M Wade
 |  |  |  |  | G Maxwell | N Lyon
 |  |  |  |  | G Maxwell | M Starc
 |  |  |  |  | G McGrath | M Hayden
 |  |  |  |  | G McGrath | J Langer
 |  |  |  |  | G McGrath | R Ponting
 |  |  |  |  | G McGrath | M Waugh
 |  |  |  |  | G McGrath | M Clarke
 |  |  |  |  | G McGrath | S Waugh
 |  |  |  |  | G McGrath | J Gillespie
 |  |  |  |  | G McGrath | S Warne
 |  |  |  |  | I Healy | M Hayden
 |  |  |  |  | I Healy | J Langer
 |  |  |  |  | I Healy | R Ponting
 |  |  |  |  | I Healy | S Marsh
 |  |  |  |  | I Healy | M Marsh
 |  |  |  |  | I Healy | S Macgill
 |  |  |  |  | I Healy | M Johnson
 |  |  |  |  | J Gillespie | M Hayden
 |  |  |  |  | J Gillespie | J Langer
 |  |  |  |  | J Gillespie | R Ponting
 |  |  |  |  | J Gillespie | M Waugh
 |  |  |  |  | J Gillespie | M Clarke
 |  |  |  |  | J Gillespie | S Waugh
 |  |  |  |  | J Gillespie | S Warne
 |  |  |  |  | J Langer | M Waugh
 |  |  |  |  | J Langer | M Clarke
 |  |  |  |  | J Langer | S Waugh
 |  |  |  |  | J Langer | S Warne
 |  |  |  |  | J Langer | S Marsh
 |  |  |  |  | J Langer | M Marsh
 |  |  |  |  | J Langer | S Macgill
 |  |  |  |  | J Langer | S Smith
 |  |  |  |  | J Langer | M Wade
 |  |  |  |  | J Langer | N Lyon
 |  |  |  |  | J Langer | M Starc
 |  |  |  |  | M Clarke | M Hayden
 |  |  |  |  | M Clarke | R Ponting
 |  |  |  |  | M Clarke | M Waugh
 |  |  |  |  | M Clarke | S Waugh
 |  |  |  |  | M Clarke | S Warne
 |  |  |  |  | M Hayden | M Waugh
 |  |  |  |  | M Hayden | S Waugh
 |  |  |  |  | M Hayden | S Warne
 |  |  |  |  | M Hayden | S Marsh
 |  |  |  |  | M Hayden | M Marsh
 |  |  |  |  | M Hayden | S Macgill
 |  |  |  |  | M Hayden | S Smith
 |  |  |  |  | M Hayden | M Wade
 |  |  |  |  | M Hayden | N Lyon
 |  |  |  |  | M Hayden | M Starc
 |  |  |  |  | M Johnson | S Marsh
 |  |  |  |  | M Johnson | M Marsh
 |  |  |  |  | M Johnson | S Macgill
 |  |  |  |  | M Johnson | S Smith
 |  |  |  |  | M Johnson | M Wade
 |  |  |  |  | M Johnson | N Lyon
 |  |  |  |  | M Johnson | M Starc
 |  |  |  |  | M Marsh | R Ponting
 |  |  |  |  | M Marsh | S Marsh
 |  |  |  |  | M Marsh | S Macgill
 |  |  |  |  | M Starc | R Ponting
 |  |  |  |  | M Starc | S Smith
 |  |  |  |  | M Starc | M Wade
 |  |  |  |  | M Starc | N Lyon
 |  |  |  |  | M Wade | R Ponting
 |  |  |  |  | M Wade | S Smith
 |  |  |  |  | M Wade | N Lyon
 |  |  |  |  | M Waugh | R Ponting
 |  |  |  |  | M Waugh | S Waugh
 |  |  |  |  | M Waugh | S Warne
 |  |  |  |  | N Lyon | R Ponting
 |  |  |  |  | N Lyon | S Smith
 |  |  |  |  | R Ponting | S Waugh
 |  |  |  |  | R Ponting | S Warne
 |  |  |  |  | R Ponting | S Marsh
 |  |  |  |  | R Ponting | S Macgill
 |  |  |  |  | R Ponting | S Smith
 |  |  |  |  | S Macgill | S Marsh
 |  |  |  |  | S Warne | S Waugh
 |  |  |  |  | A Border | M Waugh
 |  |  |  |  | A Border | M Clarke
 |  |  |  |  | A Border | S Waugh
 |  |  |  |  | A Border | A Gilchrist
 |  |  |  |  | A Border | B [NAME]
 |  |  |  |  | A Border | J Gillespie
 |  |  |  |  | A Border | S Warne
 |  |  |  |  | A Border | G McGrath
 |  |  |  |  | A Border | S Smith
 |  |  |  |  | A Border | D Warner
 |  |  |  |  | A Border | M Wade
 |  |  |  |  | A Border | G Maxwell
 |  |  |  |  | A Border | N Lyon
 |  |  |  |  | A Border | M Starc
 |  |  |  |  | A Gilchrist | D Martyn
 |  |  |  |  | A Gilchrist | S Marsh
 |  |  |  |  | A Gilchrist | M Marsh
 |  |  |  |  | A Gilchrist | I Healy
 |  |  |  |  | A Gilchrist | D Fleming
 |  |  |  |  | A Gilchrist | S Macgill
 |  |  |  |  | A Gilchrist | M Johnson
 |  |  |  |  | A Gilchrist | S Smith
 |  |  |  |  | A Gilchrist | D Warner
 |  |  |  |  | A Gilchrist | M Wade
 |  |  |  |  | A Gilchrist | G Maxwell
 |  |  |  |  | A Gilchrist | N Lyon
 |  |  |  |  | A Gilchrist | M Starc
 |  |  |  |  | B [NAME] | D Martyn
 |  |  |  |  | B [NAME] | S Marsh
 |  |  |  |  | B [NAME] | M Marsh
 |  |  |  |  | B [NAME] | I Healy
 |  |  |  |  | B [NAME] | D Fleming
 |  |  |  |  | B [NAME] | S Macgill
 |  |  |  |  | B [NAME] | M Johnson
 |  |  |  |  | B [NAME] | S Smith
 |  |  |  |  | B [NAME] | D Warner
 |  |  |  |  | B [NAME] | M Wade
 |  |  |  |  | B [NAME] | G Maxwell
 |  |  |  |  | B [NAME] | N Lyon
 |  |  |  |  | B [NAME] | M Starc
 |  |  |  |  | D Fleming | M Waugh
 |  |  |  |  | D Fleming | M Clarke
 |  |  |  |  | D Fleming | S Waugh
 |  |  |  |  | D Fleming | J Gillespie
 |  |  |  |  | D Fleming | S Warne
 |  |  |  |  | D Fleming | G McGrath
 |  |  |  |  | D Fleming | S Smith
 |  |  |  |  | D Fleming | D Warner
 |  |  |  |  | D Fleming | M Wade
 |  |  |  |  | D Fleming | G Maxwell
 |  |  |  |  | D Fleming | N Lyon
 |  |  |  |  | D Fleming | M Starc
 |  |  |  |  | D Martyn | M Waugh
 |  |  |  |  | D Martyn | M Clarke
 |  |  |  |  | D Martyn | S Waugh
 |  |  |  |  | D Martyn | J Gillespie
 |  |  |  |  | D Martyn | S Warne
 |  |  |  |  | D Martyn | G McGrath
 |  |  |  |  | D Warner | M Waugh
 |  |  |  |  | D Warner | M Clarke
 |  |  |  |  | D Warner | S Waugh
 |  |  |  |  | D Warner | J Gillespie
 |  |  |  |  | D Warner | S Warne
 |  |  |  |  | D Warner | G McGrath
 |  |  |  |  | D Warner | S Marsh
 |  |  |  |  | D Warner | M Marsh
 |  |  |  |  | D Warner | I Healy
 |  |  |  |  | D Warner | S Macgill
 |  |  |  |  | G Maxwell | M Waugh
 |  |  |  |  | G Maxwell | M Clarke
 |  |  |  |  | G Maxwell | S Waugh
 |  |  |  |  | G Maxwell | J Gillespie
 |  |  |  |  | G Maxwell | S Warne
 |  |  |  |  | G Maxwell | G McGrath
 |  |  |  |  | G Maxwell | S Marsh
 |  |  |  |  | G Maxwell | M Marsh
 |  |  |  |  | G Maxwell | I Healy
 |  |  |  |  | G Maxwell | S Macgill
 |  |  |  |  | G McGrath | S Marsh
 |  |  |  |  | G McGrath | M Marsh
 |  |  |  |  | G McGrath | I Healy
 |  |  |  |  | G McGrath | S Macgill
 |  |  |  |  | G McGrath | M Johnson
 |  |  |  |  | G McGrath | S Smith
 |  |  |  |  | G McGrath | M Wade
 |  |  |  |  | G McGrath | N Lyon
 |  |  |  |  | G McGrath | M Starc
 |  |  |  |  | I Healy | M Waugh
 |  |  |  |  | I Healy | M Clarke
 |  |  |  |  | I Healy | S Waugh
 |  |  |  |  | I Healy | J Gillespie
 |  |  |  |  | I Healy | S Warne
 |  |  |  |  | I Healy | S Smith
 |  |  |  |  | I Healy | M Wade
 |  |  |  |  | I Healy | N Lyon
 |  |  |  |  | I Healy | M Starc
 |  |  |  |  | J Gillespie | S Marsh
 |  |  |  |  | J Gillespie | M Marsh
 |  |  |  |  | J Gillespie | S Macgill
 |  |  |  |  | J Gillespie | M Johnson
 |  |  |  |  | J Gillespie | S Smith
 |  |  |  |  | J Gillespie | M Wade
 |  |  |  |  | J Gillespie | N Lyon
 |  |  |  |  | J Gillespie | M Starc
 |  |  |  |  | M Clarke | S Marsh
 |  |  |  |  | M Clarke | M Marsh
 |  |  |  |  | M Clarke | S Macgill
 |  |  |  |  | M Clarke | M Johnson
 |  |  |  |  | M Clarke | S Smith
 |  |  |  |  | M Clarke | M Wade
 |  |  |  |  | M Clarke | N Lyon
 |  |  |  |  | M Clarke | M Starc
 |  |  |  |  | M Johnson | M Waugh
 |  |  |  |  | M Johnson | S Waugh
 |  |  |  |  | M Johnson | S Warne
 |  |  |  |  | M Marsh | M Waugh
 |  |  |  |  | M Marsh | S Waugh
 |  |  |  |  | M Marsh | S Warne
 |  |  |  |  | M Marsh | S Smith
 |  |  |  |  | M Marsh | M Wade
 |  |  |  |  | M Marsh | N Lyon
 |  |  |  |  | M Marsh | M Starc
 |  |  |  |  | M Starc | M Waugh
 |  |  |  |  | M Starc | S Waugh
 |  |  |  |  | M Starc | S Warne
 |  |  |  |  | M Starc | S Marsh
 |  |  |  |  | M Starc | S Macgill
 |  |  |  |  | M Wade | M Waugh
 |  |  |  |  | M Wade | S Waugh
 |  |  |  |  | M Wade | S Warne
 |  |  |  |  | M Wade | S Marsh
 |  |  |  |  | M Wade | S Macgill
 |  |  |  |  | M Waugh | S Marsh
 |  |  |  |  | M Waugh | S Macgill
 |  |  |  |  | M Waugh | S Smith
 |  |  |  |  | M Waugh | N Lyon
 |  |  |  |  | N Lyon | S Waugh
 |  |  |  |  | N Lyon | S Warne
 |  |  |  |  | N Lyon | S Marsh
 |  |  |  |  | N Lyon | S Macgill
 |  |  |  |  | S Macgill | S Waugh
 |  |  |  |  | S Macgill | S Warne
 |  |  |  |  | S Macgill | S Smith
 |  |  |  |  | S Marsh | S Waugh
 |  |  |  |  | S Marsh | S Warne
 |  |  |  |  | S Marsh | S Smith
 |  |  |  |  | S Smith | S Waugh
 |  |  |  |  | S Smith | S Warne