Spreadsheet: 754497d1636273289-creating-a-formula-to-do-a-teammate-count-team-mate-example
Sheet: Sheet1

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