{"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":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["#","Names ","Team","Teams","Members"]
[1,"R. Taylor",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C1,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C1,Teams)<>Members))))),\"\")","v":"Team B"},"Team A",4]
[2,"O. Johnson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C2,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C2,Teams)<>Members))))),\"\")","v":"Team B"},"Team B",6]
[3,"R. Williams",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C3,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C3,Teams)<>Members))))),\"\")","v":"Team B"},"Team C",3]
[4,"Z. Jones",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C4,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C4,Teams)<>Members))))),\"\")","v":"Team C"}]
[5,"T. Brown",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C5,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C5,Teams)<>Members))))),\"\")","v":"Team A"}]
[6,"V. Davis",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C6,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C6,Teams)<>Members))))),\"\")","v":"Team B"}]
[7,"O. Miller",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C7,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C7,Teams)<>Members))))),\"\")","v":"Team A"}]
[8,"F. Wilson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C8,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C8,Teams)<>Members))))),\"\")","v":"Team A"}]
[9,"D. Moore",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C9,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C9,Teams)<>Members))))),\"\")","v":"Team A"}]
[10,"G. Taylor",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C10,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C10,Teams)<>Members))))),\"\")","v":"Team C"}]
[11,"J. Thomas",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C11,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C11,Teams)<>Members))))),\"\")","v":"Team B"}]
[12,"F. Jackson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C12,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C12,Teams)<>Members))))),\"\")","v":"Team C"}]
[13,"P. White",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C13,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C13,Teams)<>Members))))),\"\")","v":"Team B"}]
[14,"E. Harris",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C14,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C14,Teams)<>Members))))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C14,Teams)<>$E$2:$E$4)*ROW($1:$3),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C14,Teams)<>$E$2:$E$4))))),\"\")","v":""}]
[15,"U. Martin",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C15,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C15,Teams)<>Members))))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C15,Teams)<>$E$2:$E$4)*ROW($1:$3),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C15,Teams)<>$E$2:$E$4))))),\"\")","v":""}]
[16,"A. Thompson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C16,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C16,Teams)<>Members))))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C16,Teams)<>$E$2:$E$4)*ROW($1:$3),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C16,Teams)<>$E$2:$E$4))))),\"\")","v":""}]
[17,"S. Garcia",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C17,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C17,Teams)<>Members))))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C17,Teams)<>$E$2:$E$4)*ROW($1:$3),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C17,Teams)<>$E$2:$E$4))))),\"\")","v":""}]
[18,"A. Martinez",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C18,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C18,Teams)<>Members))))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C18,Teams)<>$E$2:$E$4)*ROW($1:$3),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C18,Teams)<>$E$2:$E$4))))),\"\")","v":""}]
[19,"Z. Robinson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C19,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C19,Teams)<>Members))))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C19,Teams)<>$E$2:$E$4)*ROW($1:$3),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C19,Teams)<>$E$2:$E$4))))),\"\")","v":""}]
[20,"E. Rodriguez",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C20,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C20,Teams)<>Members))))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C20,Teams)<>$E$2:$E$4)*ROW($1:$3),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C20,Teams)<>$E$2:$E$4))))),\"\")","v":""}]
[]
["Press F9 to recalculate"]