{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["797","List","SubList","List (an)","SubList (an)","798","798 (an)","799","799 (an)","800","800 (an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"797","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Other related videos:"]
["Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula"]
["Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula"]
["Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula"]
["Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula"]

{"sheet":"List","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["List","Checked = y"]
["Eggs"]
["Honey"]
["Flour"]
["Spam"]
["Bread"]
["Apples"]
["Oranges"]
["Grapes"]

{"sheet":"SubList","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Count"]
[]
["Records"]

{"sheet":"List (an)","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["List","Checked = y"]
["Eggs"]
["Honey",null,null,2,2]
["Flour","y",null,null,4]
["Spam","y",null,4,8]
["Bread"]
["Apples"]
["Oranges","y"]
["Grapes","y",null,8]

{"sheet":"SubList (an)","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Count",{"$f":"COUNTIF('List (an)'!B2:B9,\"y\")","v":4}]
[]
["Records"]
[{"$f":"IF(ROWS(A$4:A4)>$B$1,\"\",INDEX('List (an)'!$A$2:$A$9,_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(A$4:A4))))","v":"Flour"},null,null,2,{"$f":"_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(E$4:E4))","v":3}]
[{"$f":"IF(ROWS(A$4:A5)>$B$1,\"\",INDEX('List (an)'!$A$2:$A$9,_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(A$4:A5))))","v":"Spam"},null,null,4,{"$f":"_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(E$4:E5))","v":4}]
[{"$f":"IF(ROWS(A$4:A6)>$B$1,\"\",INDEX('List (an)'!$A$2:$A$9,_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(A$4:A6))))","v":"Oranges"},null,null,8,{"$f":"_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(E$4:E6))","v":7}]
[{"$f":"IF(ROWS(A$4:A7)>$B$1,\"\",INDEX('List (an)'!$A$2:$A$9,_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(A$4:A7))))","v":"Grapes"},null,null,null,{"$f":"_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(E$4:E7))","v":8}]
[{"$f":"IF(ROWS(A$4:A8)>$B$1,\"\",INDEX('List (an)'!$A$2:$A$9,_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(A$4:A8))))","v":""},null,null,null,{"$f":"_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(E$4:E8))","v":{"$error":"#NUM!"}}]
[{"$f":"IF(ROWS(A$4:A9)>$B$1,\"\",INDEX('List (an)'!$A$2:$A$9,_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(A$4:A9))))","v":""},null,null,null,{"$f":"_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(E$4:E9))","v":{"$error":"#NUM!"}}]
[{"$f":"IF(ROWS(A$4:A10)>$B$1,\"\",INDEX('List (an)'!$A$2:$A$9,_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(A$4:A10))))","v":""},null,null,null,{"$f":"_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(E$4:E10))","v":{"$error":"#NUM!"}}]
[{"$f":"IF(ROWS(A$4:A11)>$B$1,\"\",INDEX('List (an)'!$A$2:$A$9,_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(A$4:A11))))","v":""},null,null,null,{"$f":"_xlfn.AGGREGATE(15,6,(ROW('List (an)'!$A$2:$A$9)-ROW('List (an)'!$A$2)+1)/('List (an)'!$B$2:$B$9=\"y\"),ROWS(E$4:E11))","v":{"$error":"#NUM!"}}]

{"sheet":"798","index":5,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Phone","More Info",null,"Search for","Count"]
["F5","Jo","772-669 - 3248","IXRLG",null,"mann"]
["F7","Job","520-456 - 5743","YDNYW"]
["F3","Johnny","667-777 - 7938","RIBIM",null,"First Name","Last Name","Phone","More Info"]
["F1","Johnsey","626-618 - 8511","OOOPU"]
["F2","Johnson","592-454 - 9009","OKDAX"]
["F6","Joonipher","792-232 - 5616","NYRSM"]
["F4","Joseph","878-485 - 3855","DBMBD"]
["F15","Mab","571-763 - 4579","MRSHU"]
["F14","Maffer","684-360 - 3014","UPVDT"]
["F18","Mag","704-420 - 6964","WGNQH"]
["F16","Magger","752-712 - 9835","IDZJR"]
["F13","Manard","506-783 - 7876","IBZXF"]
["F11","Manferd","811-770 - 5210","GLAZQ"]
["F9","Mango","630-407 - 4622","IVAWQ"]
["F12","Mannard","578-591 - 3051","UGUEL"]
["F10","Manner","871-209 - 7127","DCUVM"]
["F8","Manner","826-865 - 2816","FEYKQ"]
["F17","Massive","711-622 - 7671","GFRDY"]

{"sheet":"798 (an)","index":6,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Phone","More Info",null,"Search for","Count"]
["F5","Jo","772-669 - 3248","IXRLG",null,"Joo",{"$f":"SUMPRODUCT(--ISNUMBER(SEARCH($F$2,$B$2:$B$19)))","v":1}]
["F7","Job","520-456 - 5743","YDNYW"]
["F3","Johnny","667-777 - 7938","RIBIM",null,"First Name","Last Name","Phone","More Info"]
["F1","Johnsey","626-618 - 8511","OOOPU",null,{"$f":"IF(ROWS(F$5:F5)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F5))))","v":"F6"},{"$f":"IF(ROWS(G$5:G5)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G5))))","v":"Joonipher"},{"$f":"IF(ROWS(H$5:H5)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H5))))","v":"792-232 - 5616"},{"$f":"IF(ROWS(I$5:I5)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I5))))","v":"NYRSM"}]
["F2","Johnson","592-454 - 9009","OKDAX",null,{"$f":"IF(ROWS(F$5:F6)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F6))))","v":""},{"$f":"IF(ROWS(G$5:G6)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G6))))","v":""},{"$f":"IF(ROWS(H$5:H6)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H6))))","v":""},{"$f":"IF(ROWS(I$5:I6)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I6))))","v":""}]
["F6","Joonipher","792-232 - 5616","NYRSM",null,{"$f":"IF(ROWS(F$5:F7)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F7))))","v":""},{"$f":"IF(ROWS(G$5:G7)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G7))))","v":""},{"$f":"IF(ROWS(H$5:H7)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H7))))","v":""},{"$f":"IF(ROWS(I$5:I7)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I7))))","v":""}]
["F4","Joseph","878-485 - 3855","DBMBD",null,{"$f":"IF(ROWS(F$5:F8)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F8))))","v":""},{"$f":"IF(ROWS(G$5:G8)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G8))))","v":""},{"$f":"IF(ROWS(H$5:H8)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H8))))","v":""},{"$f":"IF(ROWS(I$5:I8)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I8))))","v":""}]
["F15","Mab","571-763 - 4579","MRSHU",null,{"$f":"IF(ROWS(F$5:F9)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F9))))","v":""},{"$f":"IF(ROWS(G$5:G9)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G9))))","v":""},{"$f":"IF(ROWS(H$5:H9)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H9))))","v":""},{"$f":"IF(ROWS(I$5:I9)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I9))))","v":""}]
["F14","Maffer","684-360 - 3014","UPVDT",null,{"$f":"IF(ROWS(F$5:F10)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F10))))","v":""},{"$f":"IF(ROWS(G$5:G10)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G10))))","v":""},{"$f":"IF(ROWS(H$5:H10)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H10))))","v":""},{"$f":"IF(ROWS(I$5:I10)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I10))))","v":""}]
["F18","Mag","704-420 - 6964","WGNQH",null,{"$f":"IF(ROWS(F$5:F11)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F11))))","v":""},{"$f":"IF(ROWS(G$5:G11)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G11))))","v":""},{"$f":"IF(ROWS(H$5:H11)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H11))))","v":""},{"$f":"IF(ROWS(I$5:I11)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I11))))","v":""}]
["F16","Magger","752-712 - 9835","IDZJR",null,{"$f":"IF(ROWS(F$5:F12)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F12))))","v":""},{"$f":"IF(ROWS(G$5:G12)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G12))))","v":""},{"$f":"IF(ROWS(H$5:H12)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H12))))","v":""},{"$f":"IF(ROWS(I$5:I12)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I12))))","v":""}]
["F13","Manard","506-783 - 7876","IBZXF",null,{"$f":"IF(ROWS(F$5:F13)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F13))))","v":""},{"$f":"IF(ROWS(G$5:G13)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G13))))","v":""},{"$f":"IF(ROWS(H$5:H13)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H13))))","v":""},{"$f":"IF(ROWS(I$5:I13)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I13))))","v":""}]
["F11","Manferd","811-770 - 5210","GLAZQ",null,{"$f":"IF(ROWS(F$5:F14)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F14))))","v":""},{"$f":"IF(ROWS(G$5:G14)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G14))))","v":""},{"$f":"IF(ROWS(H$5:H14)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H14))))","v":""},{"$f":"IF(ROWS(I$5:I14)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I14))))","v":""}]
["F9","Mango","630-407 - 4622","IVAWQ",null,{"$f":"IF(ROWS(F$5:F15)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F15))))","v":""},{"$f":"IF(ROWS(G$5:G15)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G15))))","v":""},{"$f":"IF(ROWS(H$5:H15)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H15))))","v":""},{"$f":"IF(ROWS(I$5:I15)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I15))))","v":""}]
["F12","Mannard","578-591 - 3051","UGUEL",null,{"$f":"IF(ROWS(F$5:F16)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F16))))","v":""},{"$f":"IF(ROWS(G$5:G16)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G16))))","v":""},{"$f":"IF(ROWS(H$5:H16)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H16))))","v":""},{"$f":"IF(ROWS(I$5:I16)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I16))))","v":""}]
["F10","Manner","871-209 - 7127","DCUVM",null,{"$f":"IF(ROWS(F$5:F17)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F17))))","v":""},{"$f":"IF(ROWS(G$5:G17)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G17))))","v":""},{"$f":"IF(ROWS(H$5:H17)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H17))))","v":""},{"$f":"IF(ROWS(I$5:I17)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I17))))","v":""}]
["F8","Manner","826-865 - 2816","FEYKQ",null,{"$f":"IF(ROWS(F$5:F18)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F18))))","v":""},{"$f":"IF(ROWS(G$5:G18)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G18))))","v":""},{"$f":"IF(ROWS(H$5:H18)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H18))))","v":""},{"$f":"IF(ROWS(I$5:I18)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I18))))","v":""}]
["F17","Massive","711-622 - 7671","GFRDY",null,{"$f":"IF(ROWS(F$5:F19)>$G$2,\"\",INDEX(A$2:A$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(F$5:F19))))","v":""},{"$f":"IF(ROWS(G$5:G19)>$G$2,\"\",INDEX(B$2:B$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(G$5:G19))))","v":""},{"$f":"IF(ROWS(H$5:H19)>$G$2,\"\",INDEX(C$2:C$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(H$5:H19))))","v":""},{"$f":"IF(ROWS(I$5:I19)>$G$2,\"\",INDEX(D$2:D$19,_xlfn.AGGREGATE(15,6,(ROW($B$2:$B$19)-ROW($B$2)+1)/ISNUMBER(SEARCH($F$2,$B$2:$B$19)),ROWS(I$5:I19))))","v":""}]

{"sheet":"799","index":7,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["John Smith","Day 1","Day 2","Day 3","Day 4","Day 5"]
["Job 1","Override","Not Done",null,"Over"]
["Job 2","Done","Ongoing",null,null,"Canceled"]
["Job 3","Under",null,null," ++ Good"]

{"sheet":"799 (an)","index":8,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Jone","Day 1","Day 2","Day 3","Day 4","Day 5"]
["Job 1","Override","Not Done",null,"Over"]
["Job 2",null,"Ongoing",null,null,"Canceled"]
["Job 3","Under",null,null," ++ Good"]
[]
[{"$f":"TRANSPOSE(IF(A1:F4=\"\",\"--\",A1:F4))","v":"Jone"},"Job 1","Job 2","Job 3"]
["Day 1","Override","--","Under"]
["Day 2","Not Done","Ongoing","--"]
["Day 3","--","--","--"]
["Day 4","Over","--"," ++ Good"]
["Day 5","--","Canceled","--"]

{"sheet":"800","index":9,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Lookup Table"]
[null,"Frequency","Week 1","Week 2","Week 3","Week 4"]
[null,1,1.75]
[null,2,1.75,null,1.75]
[null,4,1.75,1.75,1.75,1.75]
[]
[null,"Site inspections"]
["Job#","Frequency","Week 1","Week 2","Week 3","Week 4"]
["AB101",1]
["AB102",4]
["AB103",2]
["AB104"]
["AB105"]
["AB106"]
["AB107"]

{"sheet":"800 (an)","index":10,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Lookup Table"]
[null,"Frequency","Week 1","Week 2","Week 3","Week 4"]
[null,0,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,1,1.75,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,2,1.75,{"$f":"\"\"","v":""},1.75,{"$f":"\"\"","v":""}]
[null,4,1.75,1.75,1.75,1.75]
[]
[null,"Site inspections"]
["Job#","Frequency","Week 1","Week 2","Week 3","Week 4"]
["AB101",1,{"$f":"VLOOKUP($B10,$B$3:$F$6,COLUMNS($C10:C10)+1,0)","v":1.75},{"$f":"VLOOKUP($B10,$B$3:$F$6,COLUMNS($C10:D10)+1,0)","v":""},{"$f":"VLOOKUP($B10,$B$3:$F$6,COLUMNS($C10:E10)+1,0)","v":""},{"$f":"VLOOKUP($B10,$B$3:$F$6,COLUMNS($C10:F10)+1,0)","v":""}]
["AB102",4,{"$f":"VLOOKUP($B11,$B$3:$F$6,COLUMNS($C11:C11)+1,0)","v":1.75},{"$f":"VLOOKUP($B11,$B$3:$F$6,COLUMNS($C11:D11)+1,0)","v":1.75},{"$f":"VLOOKUP($B11,$B$3:$F$6,COLUMNS($C11:E11)+1,0)","v":1.75},{"$f":"VLOOKUP($B11,$B$3:$F$6,COLUMNS($C11:F11)+1,0)","v":1.75}]
["AB103",2,{"$f":"VLOOKUP($B12,$B$3:$F$6,COLUMNS($C12:C12)+1,0)","v":1.75},{"$f":"VLOOKUP($B12,$B$3:$F$6,COLUMNS($C12:D12)+1,0)","v":""},{"$f":"VLOOKUP($B12,$B$3:$F$6,COLUMNS($C12:E12)+1,0)","v":1.75},{"$f":"VLOOKUP($B12,$B$3:$F$6,COLUMNS($C12:F12)+1,0)","v":""}]
["AB104",2,{"$f":"VLOOKUP($B13,$B$3:$F$6,COLUMNS($C13:C13)+1,0)","v":1.75},{"$f":"VLOOKUP($B13,$B$3:$F$6,COLUMNS($C13:D13)+1,0)","v":""},{"$f":"VLOOKUP($B13,$B$3:$F$6,COLUMNS($C13:E13)+1,0)","v":1.75},{"$f":"VLOOKUP($B13,$B$3:$F$6,COLUMNS($C13:F13)+1,0)","v":""}]
["AB105",4,{"$f":"VLOOKUP($B14,$B$3:$F$6,COLUMNS($C14:C14)+1,0)","v":1.75},{"$f":"VLOOKUP($B14,$B$3:$F$6,COLUMNS($C14:D14)+1,0)","v":1.75},{"$f":"VLOOKUP($B14,$B$3:$F$6,COLUMNS($C14:E14)+1,0)","v":1.75},{"$f":"VLOOKUP($B14,$B$3:$F$6,COLUMNS($C14:F14)+1,0)","v":1.75}]
["AB106",1,{"$f":"VLOOKUP($B15,$B$3:$F$6,COLUMNS($C15:C15)+1,0)","v":1.75},{"$f":"VLOOKUP($B15,$B$3:$F$6,COLUMNS($C15:D15)+1,0)","v":""},{"$f":"VLOOKUP($B15,$B$3:$F$6,COLUMNS($C15:E15)+1,0)","v":""},{"$f":"VLOOKUP($B15,$B$3:$F$6,COLUMNS($C15:F15)+1,0)","v":""}]
["AB107",null,{"$f":"VLOOKUP($B16,$B$3:$F$6,COLUMNS($C16:C16)+1,0)","v":""},{"$f":"VLOOKUP($B16,$B$3:$F$6,COLUMNS($C16:D16)+1,0)","v":""},{"$f":"VLOOKUP($B16,$B$3:$F$6,COLUMNS($C16:E16)+1,0)","v":""},{"$f":"VLOOKUP($B16,$B$3:$F$6,COLUMNS($C16:F16)+1,0)","v":""}]