{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Unit","Name","Counter",null,null,"Index","Names","Count"]
[null,"All Teams","Amy",{"$f":"IF(COUNTIF($C$2:C3,Table2[[#This Row],[Name]])=1,MAX($D$2:D2)+1,0)","v":1},null,null,{"$f":"N(G2)+1","v":1},{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G3,Table2[Counter],0)),\"\")","v":"Amy"},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":2}]
[null,"All Teams","Billy",{"$f":"IF(COUNTIF($C$2:C4,Table2[[#This Row],[Name]])=1,MAX($D$2:D3)+1,0)","v":2},null,null,{"$f":"N(G3)+1","v":2},{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G4,Table2[Counter],0)),\"\")","v":"Billy"},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":2}]
[null,"All Teams","Charlie",{"$f":"IF(COUNTIF($C$2:C5,Table2[[#This Row],[Name]])=1,MAX($D$2:D4)+1,0)","v":3},null,null,3,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G5,Table2[Counter],0)),\"\")","v":"Charlie"},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":1}]
[null,"All Teams","Debbie",{"$f":"IF(COUNTIF($C$2:C6,Table2[[#This Row],[Name]])=1,MAX($D$2:D5)+1,0)","v":4},null,null,4,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G6,Table2[Counter],0)),\"\")","v":"Debbie"},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":1}]
[null,"All Teams","Eric",{"$f":"IF(COUNTIF($C$2:C7,Table2[[#This Row],[Name]])=1,MAX($D$2:D6)+1,0)","v":5},null,null,5,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G7,Table2[Counter],0)),\"\")","v":"Eric"},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":1}]
[null,"Accounting","Amy",{"$f":"IF(COUNTIF($C$2:C8,Table2[[#This Row],[Name]])=1,MAX($D$2:D7)+1,0)","v":0},null,null,6,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G8,Table2[Counter],0)),\"\")","v":"Faye"},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":1}]
[null,"Accounting","Billy",{"$f":"IF(COUNTIF($C$2:C9,Table2[[#This Row],[Name]])=1,MAX($D$2:D8)+1,0)","v":0},null,null,7,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G9,Table2[Counter],0)),\"\")","v":""},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":3}]
[null,"Accounting","Faye",{"$f":"IF(COUNTIF($C$2:C10,Table2[[#This Row],[Name]])=1,MAX($D$2:D9)+1,0)","v":6},null,null,8,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G10,Table2[Counter],0)),\"\")","v":""},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":3}]
[null,"Finance",null,{"$f":"IF(COUNTIF($C$2:C11,Table2[[#This Row],[Name]])=1,MAX($D$2:D10)+1,0)","v":0},null,null,9,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G11,Table2[Counter],0)),\"\")","v":""},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":3}]
[null,"Finance",null,{"$f":"IF(COUNTIF($C$2:C12,Table2[[#This Row],[Name]])=1,MAX($D$2:D11)+1,0)","v":0},null,null,10,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G12,Table2[Counter],0)),\"\")","v":""},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":3}]
[null,"Finance",null,{"$f":"IF(COUNTIF($C$2:C13,Table2[[#This Row],[Name]])=1,MAX($D$2:D12)+1,0)","v":0},null,null,11,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G13,Table2[Counter],0)),\"\")","v":""},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":3}]
[null,null,null,null,null,null,12,{"$f":"IFERROR(INDEX(Table2[Name],MATCH(G14,Table2[Counter],0)),\"\")","v":""},{"$f":"COUNTIF(Table2[Name],Table3[[#This Row],[Names]])","v":3}]