Spreadsheet: 83463d1283436142-counting-lists-744142_gtg836b
Sheet: Sheet1

[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | ??? | [NAME] | [NAME] | [NAME] | Alicia | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Hogan | Hogan | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | Hogan | Hogan | [NAME] | Hogan | Hogan | [NAME] | Hogan | Hogan | Hogan | Hogan | LL | [NAME] | Hogan | Hogan | Hogan
 | [NAME] | Hogan | J Abbott | LL | [NAME] | [NAME] | J Abbott | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | Randi | [NAME] | Hogan | [NAME] | Randi | Randi | Randi | Randi | Randi | Randi | Randi | Randi | Randi | Randi | Randi
 | Randi | Randi | [NAME] | Randi | Randi | Randi | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | Wood | [NAME] | [NAME] | [NAME] | Wood | Wood | Wood | Wood | Wood | Wood | Wood | Wood | Wood | Wood | Wood
 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1 | -1
 | ???,[NAME],[NAME],[NAME],[NAME],Randi,[NAME] | [NAME],[NAME],[NAME],[NAME],[NAME],[NAME],[NAME] | [NAME],[NAME],[NAME],J Abbott,Randi,[NAME],Wood | [NAME],[NAME],[NAME],LL,Natalie,Randi,[NAME] | [NAME],[NAME],[NAME],[NAME],Hogan,Randi,[NAME] | [NAME],[NAME],[NAME],[NAME],[NAME],Randi,[NAME] | [NAME],[NAME],[NAME],J Abbott,Randi,[NAME],Wood | [NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME],[NAME],[NAME],[NAME],[NAME],[NAME],Wood | [NAME],Hogan,LL,Paul,Randi,[NAME],Wood | [NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood
 | Lineup combination |  |  |  |  |  |  | Occurrence
A | [NAME] | [NAME] | Hogan | [NAME] | Randi | [NAME] | Wood | 4
B | [NAME] | [NAME] | [NAME] | Hogan | [NAME] | Randi | [NAME] | 1
C | etc.
D | etc.
E | etc.
If you want to use row 10 to create the unique listings
Unique | 12
???,[NAME],[NAME],[NAME],[NAME],Randi,[NAME] | ??? | [NAME] | [NAME] | [NAME] | [NAME] | Randi | [NAME] | 1
[NAME],[NAME],[NAME],[NAME],[NAME],[NAME],[NAME] | [NAME] | [NAME] | [NAME] | Hogan | [NAME] | Randi | [NAME] | 1
[NAME],[NAME],[NAME],J Abbott,Randi,[NAME],Wood | [NAME] | [NAME] | Hogan | J Abbott | Randi | [NAME] | Wood | 2
[NAME],[NAME],[NAME],LL,Natalie,Randi,[NAME] | [NAME] | [NAME] | Hogan | LL | [NAME] | Randi | [NAME] | 1
[NAME],[NAME],[NAME],[NAME],Hogan,Randi,[NAME] | Alicia | [NAME] | [NAME] | [NAME] | Hogan | Randi | [NAME] | 1
[NAME],[NAME],[NAME],[NAME],[NAME],Randi,[NAME] | [NAME] | [NAME] | Hogan | [NAME] | [NAME] | Randi | [NAME] | 1
[NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME] | [NAME] | [NAME] | [NAME] | Randi | [NAME] | Wood | 1
[NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME] | [NAME] | Hogan | [NAME] | Randi | [NAME] | Wood | 4
[NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME] | [NAME] | Hogan | [NAME] | Randi | [NAME] | Wood | 2
[NAME],[NAME],[NAME],[NAME],[NAME],[NAME],Wood | [NAME] | [NAME] | Hogan | [NAME] | Randi | [NAME] | Wood | 1
[NAME],Hogan,LL,Paul,Randi,[NAME],Wood | [NAME] | Hogan | LL | [NAME] | Randi | [NAME] | Wood | 1
[NAME],[NAME],[NAME],[NAME],Randi,[NAME],Wood | [NAME] | Hogan | [NAME] | [NAME] | Randi | [NAME] | Wood | 1