{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Cover","Navigator","Style Guide","Model Parameters","First List","Second List","Third List","Fourth List","Fifth List","Lookup Data","Summary Table","PivotTable Result","Error Checks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":39,"comments":0,"pivot_tables":1},"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":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"SumProduct Pty Ltd"}]
[null,null,{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"How to compare lists using PivotTables."]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,{"$f":"Overall_Error_Check","v":0}]
[]
[]
[null,1,"Table of Contents"]
[]
[null,null,null,null,null,"Cover"]
[null,null,null,null,null,"Style Guide"]
[null,null,null,null,null,"Model Parameters"]
[null,null,null,null,null,"First List"]
[null,null,null,null,null,"Second List"]
[null,null,null,null,null,"Third List"]
[null,null,null,null,null,"Fourth List"]
[null,null,null,null,null,"Fifth List"]
[null,null,null,null,null,"Lookup Data"]
[null,null,null,null,null,"Summary Table"]
[null,null,null,null,null,"PivotTable Result"]
[null,null,null,null,null,"Error Checks"]

{"sheet":"Style Guide","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[80,2,80,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[61,2,61,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[57,2,57,6],[59,2,59,6],[60,2,60,6],[46,2,46,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[34,2,34,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[16,2,16,6],[2,0,2,4],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Style Guide"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Formatting of Headers / Dividers"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Sheet Title",null,null,null,null,null,{"$f":"C10","v":"Sheet Title"},null,"Sheet Title"]
[null,null,"Model Name",null,null,null,null,null,{"$f":"C11","v":"Model Name"},null,"Model Name"]
[]
[null,null,"Header 1",null,null,null,null,null,{"$f":"C13","v":"Header 1"},null,"Header 1"]
[null,null,"Header 2",null,null,null,null,null,{"$f":"C14","v":"Header 2"},null,"Header 2"]
[null,null,"Header 3",null,null,null,null,null,{"$f":"C15","v":"Header 3"},null,"Header 3"]
[null,null,"Header 4",null,null,null,null,null,{"$f":"C16","v":"Header 4"},null,"Header 4"]
[]
[null,null,"Notes",null,null,null,null,null,{"$f":"C18","v":"Notes"},null,"Notes"]
[]
[null,null,"Table Heading",null,null,null,null,null,{"$f":"C20","v":"Table Heading"},null,"Table Heading"]
[]
[]
[null,{"$f":"MAX($B$5:$B22)+1","v":2},"Individual Cell Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Assumption",null,null,null,null,null,"Assumption",null,{"$f":"C27","v":"Assumption"}]
[]
[null,null,"Constraint",null,null,null,null,null,{"$f":"C29","v":"Constraint"},null,{"$f":"C29","v":"Constraint"}]
[]
[null,null,"Empty",null,null,null,null,null,null,null,{"$f":"C31","v":"Empty"}]
[]
[null,null,"Error Check",null,null,null,null,null,0,null,{"$f":"C33","v":"Error Check"}]
[]
[null,null,"Hyperlink",null,null,null,null,null,"Hyperlink",null,{"$f":"C35","v":"Hyperlink"}]
[]
[null,null,"Internal Reference",null,null,null,null,null,{"$f":"'Error Checks'!E12","v":"No checks present"},null,{"$f":"C37","v":"Internal Reference"}]
[]
[null,null,"Line Calculation",null,null,null,null,null,77,null,"Line Calc"]
[]
[null,null,"Line Total",null,null,null,null,null,{"$f":"I39","v":77},null,{"$f":"C41","v":"Line Total"}]
[]
[null,null,"Parameter",null,null,null,null,null,365,null,{"$f":"C43","v":"Parameter"}]
[]
[null,null,"Range Name Description",null,null,null,null,null,"Not_Named",null,{"$f":"C45","v":"Range Name Description"}]
[]
[null,null,"Row Reference",null,null,null,null,null,{"$f":"ROW(C47)","v":47},null,"Row Ref"]
[]
[null,null,"Row Summary",null,null,null,null,null,{"$f":"I41","v":77},null,{"$f":"C49","v":"Row Summary"}]
[]
[null,null,"Units",null,null,null,null,null,"A$",null,{"$f":"C51","v":"Units"}]
[]
[null,null,"WIP",null,null,null,null,null,null,null,{"$f":"C53","v":"WIP"}]
[]
[]
[null,{"$f":"MAX($B$5:$B55)+1","v":3},"Numerical Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Comma",null,null,null,null,null,123456.789,null,{"$f":"C60","v":"Comma"}]
[]
[null,null,"Comma [0]",null,null,null,null,null,-123456.789,null,"Comma [0]"]
[]
[null,null,"Currency",null,null,null,null,null,123456.789,null,"Currency"]
[]
[null,null,"Currency [0]",null,null,null,null,null,123456.789,null,"Currency [0]"]
[]
[null,null,"Date",null,null,null,null,null,{"$f":"TODAY()","v":"2016-03-23"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2016-03-23"},null,{"$f":"C70","v":"Date Heading"}]
[]
[null,null,"Numbers 0",null,null,null,null,null,-123456.789,null,{"$f":"C72","v":"Numbers 0"}]
[]
[null,null,"Percent",null,null,null,null,null,0.5,null,{"$f":"C74","v":"Percent"}]

{"sheet":"Model Parameters","index":3,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4],[10,6,10,13],[11,6,11,13]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Model Parameters"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"General"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[null,null,null,null,"Model Name",null,{"$f":"IF(ISERROR(OR(FIND(\"[\",CELL(\"filename\",A1)),FIND(\"]\",CELL(\"filename\",A1)))),\"\",MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1))","v":"SP - Comparing Lists.xlsm"}]
[null,null,null,null,"Client Name",null,"SumProduct Pty Ltd"]
[]
[]
[null,{"$f":"MAX($B$5:$B14)+1","v":2},"General Range Names"]
[]
[null,null,"Technical Assumptions"]
[]
[null,null,null,null,"Days in Year",null,365]
[null,null,null,null,"Months in Month",null,1]
[null,null,null,null,"Months in Quarter",null,3]
[null,null,null,null,"Months in Half Yr",null,6]
[null,null,null,null,"Months in Year",null,12]
[null,null,null,null,"Quarters in Year",null,4]
[]
[null,null,null,null,"Rounding Accuracy",null,5]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98]
[null,null,null,null,"Very Small Number",null,1E-8]
[]
[null,null,null,null,"Thousand",null,1000]

{"sheet":"First List","index":4,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"First List"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"First List"}]
[]
[null,null,"Table 1"]
[]
[null,null,null,"Input Data"]
[]
[null,null,null,null,null,null,"Counter","Colour"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":1},"Red"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":2},"Orange"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":3},"Indigo"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":4},"Green"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":5},"Pink"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":6},"White"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":7},"Black"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":8},"Orange"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":9},"Purple"]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(3,INDEX(First_Table[Colour],1):First_Table[[#This Row],[Colour]])","v":10},"Turquoise"]

{"sheet":"Second List","index":5,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Second List"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Second List"}]
[]
[null,null,"Table 2"]
[]
[null,null,null,"Input Data"]
[]
[null,null,null,null,null,null,"Counter","Colour"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":11},"Yellow"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":12},"Indigo"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":13},"Black"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":14},"Pink"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":15},"Cyan"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":16},"White"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":17},"Blue"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":18},"Brown"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":19},"Red "]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":20},"Purple"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":21},"Mauve"]
[null,null,null,null,null,null,{"$f":"MAX(First_Table[Counter])+SUBTOTAL(3,INDEX(Second_Table[Colour],1):Second_Table[[#This Row],[Colour]])","v":22},"Magenta"]

{"sheet":"Third List","index":6,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Third List"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Third List"}]
[]
[null,null,"Table 3"]
[]
[null,null,null,"Input Data"]
[]
[null,null,null,null,null,null,"Counter","Colour"]
[null,null,null,null,null,null,{"$f":"MAX(Second_Table[Counter])+SUBTOTAL(3,INDEX(Third_Table[Colour],1):Third_Table[[#This Row],[Colour]])","v":23},"Red"]
[null,null,null,null,null,null,{"$f":"MAX(Second_Table[Counter])+SUBTOTAL(3,INDEX(Third_Table[Colour],1):Third_Table[[#This Row],[Colour]])","v":24},"Orange"]
[null,null,null,null,null,null,{"$f":"MAX(Second_Table[Counter])+SUBTOTAL(3,INDEX(Third_Table[Colour],1):Third_Table[[#This Row],[Colour]])","v":25},"Black"]
[null,null,null,null,null,null,{"$f":"MAX(Second_Table[Counter])+SUBTOTAL(3,INDEX(Third_Table[Colour],1):Third_Table[[#This Row],[Colour]])","v":26},"Yellow"]
[null,null,null,null,null,null,{"$f":"MAX(Second_Table[Counter])+SUBTOTAL(3,INDEX(Third_Table[Colour],1):Third_Table[[#This Row],[Colour]])","v":27},"Indigo"]
[null,null,null,null,null,null,{"$f":"MAX(Second_Table[Counter])+SUBTOTAL(3,INDEX(Third_Table[Colour],1):Third_Table[[#This Row],[Colour]])","v":28},"Blue"]
[null,null,null,null,null,null,{"$f":"MAX(Second_Table[Counter])+SUBTOTAL(3,INDEX(Third_Table[Colour],1):Third_Table[[#This Row],[Colour]])","v":29},"Green"]

{"sheet":"Fourth List","index":7,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Fourth List"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Fourth List"}]
[]
[null,null,"Table 4"]
[]
[null,null,null,"Input Data"]
[]
[null,null,null,null,null,null,"Counter","Colour"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":30},"Violet"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":31},"White"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":32},"Pink"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":33},"Magenta"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":34},"Red"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":35},"Green"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":36},"Orange"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":37},"Blue"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":38},"Turquoise"]
[null,null,null,null,null,null,{"$f":"MAX(Third_Table[Counter])+SUBTOTAL(3,INDEX(Fourth_Table[Colour],1):Fourth_Table[[#This Row],[Colour]])","v":39},"Black"]

{"sheet":"Fifth List","index":8,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Fifth List"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Fifth List"}]
[]
[null,null,"Table 5"]
[]
[null,null,null,"Input Data"]
[]
[null,null,null,null,null,null,"Counter","Colour"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":40},"Red"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":41},"Orange"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":42},"Yellow"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":43},"Green"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":44},"Blue"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":45},"Indigo"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":46},"Violet"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":47},"Black"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":48},"White"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":49},"Pink"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":50},"Magenta"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":51},"Cyan"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":52},"Turquoise"]
[null,null,null,null,null,null,{"$f":"MAX(Fourth_Table[Counter])+SUBTOTAL(3,INDEX(Fifth_Table[Colour],1):Fifth_Table[[#This Row],[Colour]])","v":53},"Mauve"]

{"sheet":"Lookup Data","index":9,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Lookup Data"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Lookup Data"}]
[]
[null,null,"Table Search"]
[]
[null,null,null,"Input Data"]
[]
[null,null,null,null,null,"Table","Min","Max","Table Name"]
[null,null,null,null,null,1,{"$f":"MIN(First_Table[Counter])","v":1},{"$f":"MAX(First_Table[Counter])","v":10},{"$f":"'First List'!C8","v":"Table 1"}]
[null,null,null,null,null,2,{"$f":"MIN(Second_Table[Counter])","v":11},{"$f":"MAX(Second_Table[Counter])","v":22},{"$f":"'Second List'!C8","v":"Table 2"}]
[null,null,null,null,null,3,{"$f":"MIN(Third_Table[Counter])","v":23},{"$f":"MAX(Third_Table[Counter])","v":29},{"$f":"'Third List'!C8","v":"Table 3"}]
[null,null,null,null,null,4,{"$f":"MIN(Fourth_Table[Counter])","v":30},{"$f":"MAX(Fourth_Table[Counter])","v":39},{"$f":"'Fourth List'!C8","v":"Table 4"}]
[null,null,null,null,null,5,{"$f":"MIN(Fifth_Table[Counter])","v":40},{"$f":"MAX(Fifth_Table[Counter])","v":53},{"$f":"'Fifth List'!C8","v":"Table 5"}]

{"sheet":"Summary Table","index":10,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Summary Table"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Summary Table"}]
[]
[null,null,"Non-Power Query Approach"]
[]
[null,null,null,"Consolidated Summary"]
[]
[null,null,null,null,null,"Max Counter",null,{"$f":"MAX('Lookup Data'!G13:H17)","v":53},{"$f":"(MAX(Summary_Table[Counter])<>H12)*1","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Counter","Table Number","Colour","Table Name"]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H15)=$H$12,\"\",N(H15)+1)","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Red"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H16)=$H$12,\"\",N(H16)+1)","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Orange"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H17)=$H$12,\"\",N(H17)+1)","v":3},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Indigo"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H18)=$H$12,\"\",N(H18)+1)","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Green"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H19)=$H$12,\"\",N(H19)+1)","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Pink"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H20)=$H$12,\"\",N(H20)+1)","v":6},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"White"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H21)=$H$12,\"\",N(H21)+1)","v":7},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Black"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H22)=$H$12,\"\",N(H22)+1)","v":8},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Orange"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H23)=$H$12,\"\",N(H23)+1)","v":9},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Purple"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H24)=$H$12,\"\",N(H24)+1)","v":10},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":1},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Turquoise"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 1"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H25)=$H$12,\"\",N(H25)+1)","v":11},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Yellow"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H26)=$H$12,\"\",N(H26)+1)","v":12},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Indigo"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H27)=$H$12,\"\",N(H27)+1)","v":13},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Black"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H28)=$H$12,\"\",N(H28)+1)","v":14},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Pink"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H29)=$H$12,\"\",N(H29)+1)","v":15},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Cyan"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H30)=$H$12,\"\",N(H30)+1)","v":16},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"White"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H31)=$H$12,\"\",N(H31)+1)","v":17},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Blue"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H32)=$H$12,\"\",N(H32)+1)","v":18},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Brown"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H33)=$H$12,\"\",N(H33)+1)","v":19},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Red "},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H34)=$H$12,\"\",N(H34)+1)","v":20},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Purple"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H35)=$H$12,\"\",N(H35)+1)","v":21},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Mauve"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H36)=$H$12,\"\",N(H36)+1)","v":22},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":2},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Magenta"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 2"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H37)=$H$12,\"\",N(H37)+1)","v":23},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":3},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Red"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 3"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H38)=$H$12,\"\",N(H38)+1)","v":24},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":3},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Orange"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 3"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H39)=$H$12,\"\",N(H39)+1)","v":25},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":3},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Black"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 3"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H40)=$H$12,\"\",N(H40)+1)","v":26},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":3},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Yellow"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 3"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H41)=$H$12,\"\",N(H41)+1)","v":27},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":3},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Indigo"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 3"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H42)=$H$12,\"\",N(H42)+1)","v":28},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":3},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Blue"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 3"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H43)=$H$12,\"\",N(H43)+1)","v":29},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":3},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Green"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 3"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H44)=$H$12,\"\",N(H44)+1)","v":30},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Violet"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H45)=$H$12,\"\",N(H45)+1)","v":31},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"White"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H46)=$H$12,\"\",N(H46)+1)","v":32},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Pink"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H47)=$H$12,\"\",N(H47)+1)","v":33},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Magenta"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H48)=$H$12,\"\",N(H48)+1)","v":34},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Red"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H49)=$H$12,\"\",N(H49)+1)","v":35},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Green"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H50)=$H$12,\"\",N(H50)+1)","v":36},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Orange"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H51)=$H$12,\"\",N(H51)+1)","v":37},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Blue"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H52)=$H$12,\"\",N(H52)+1)","v":38},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Turquoise"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H53)=$H$12,\"\",N(H53)+1)","v":39},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":4},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Black"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 4"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H54)=$H$12,\"\",N(H54)+1)","v":40},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Red"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H55)=$H$12,\"\",N(H55)+1)","v":41},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Orange"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H56)=$H$12,\"\",N(H56)+1)","v":42},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Yellow"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H57)=$H$12,\"\",N(H57)+1)","v":43},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Green"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H58)=$H$12,\"\",N(H58)+1)","v":44},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Blue"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H59)=$H$12,\"\",N(H59)+1)","v":45},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Indigo"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H60)=$H$12,\"\",N(H60)+1)","v":46},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Violet"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H61)=$H$12,\"\",N(H61)+1)","v":47},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Black"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H62)=$H$12,\"\",N(H62)+1)","v":48},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"White"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H63)=$H$12,\"\",N(H63)+1)","v":49},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Pink"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H64)=$H$12,\"\",N(H64)+1)","v":50},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Magenta"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H65)=$H$12,\"\",N(H65)+1)","v":51},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Cyan"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H66)=$H$12,\"\",N(H66)+1)","v":52},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Turquoise"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H67)=$H$12,\"\",N(H67)+1)","v":53},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":5},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":"Mauve"},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":"Table 5"}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H68)=$H$12,\"\",N(H68)+1)","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H69)=$H$12,\"\",N(H69)+1)","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H70)=$H$12,\"\",N(H70)+1)","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H71)=$H$12,\"\",N(H71)+1)","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H72)=$H$12,\"\",N(H72)+1)","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H73)=$H$12,\"\",N(H73)+1)","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(MAX($H$15:$H74)=$H$12,\"\",N(H74)+1)","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",LOOKUP(Summary_Table[[#This Row],[Counter]],Table_Summary[Min],Table_Summary[Table]))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",\nLOOKUP(Summary_Table[[#This Row],[Counter]],CHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Counter],Second_Table[Counter],Third_Table[Counter],Fourth_Table[Counter],Fifth_Table[Counter]),\nCHOOSE(Summary_Table[[#This Row],[Table Number]],First_Table[Colour],Second_Table[Colour],Third_Table[Colour],Fourth_Table[Colour],Fifth_Table[Colour])))","v":""},{"$f":"IF(Summary_Table[[#This Row],[Counter]]=\"\",\"\",INDEX('Lookup Data'!$I$13:$I$17,Summary_Table[[#This Row],[Table Number]]))","v":""}]

{"sheet":"PivotTable Result","index":11,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"PivotTable Result"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"PivotTable Result"}]
[]
[null,null,"Non-Power Query Approach"]
[]
[null,null,null,"Consolidated Summary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,"Table 1","Table 2","Table 3","Table 4","Table 5"]
[null,null,null,null,null,null,"Black",1,1,1,1,1]
[null,null,null,null,null,null,"Blue",null,1,1,1,1]
[null,null,null,null,null,null,"Brown",null,1]
[null,null,null,null,null,null,"Cyan",null,1,null,null,1]
[null,null,null,null,null,null,"Green",1,null,1,1,1]
[null,null,null,null,null,null,"Indigo",1,1,1,null,1]
[null,null,null,null,null,null,"Magenta",null,1,null,1,1]
[null,null,null,null,null,null,"Mauve",null,1,null,null,1]
[null,null,null,null,null,null,"Orange",2,null,1,1,1]
[null,null,null,null,null,null,"Pink",1,1,null,1,1]
[null,null,null,null,null,null,"Purple",1,1]
[null,null,null,null,null,null,"Red",1,null,1,1,1]
[null,null,null,null,null,null,"Red ",null,1]
[null,null,null,null,null,null,"Turquoise",1,null,null,1,1]
[null,null,null,null,null,null,"Violet",null,null,null,1,1]
[null,null,null,null,null,null,"White",1,1,null,1,1]
[null,null,null,null,null,null,"Yellow",null,1,1,null,1]

{"sheet":"Error Checks","index":12,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Error Checks"}]
[{"$f":"Model_Name","v":"SP - Comparing Lists.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Error Checks"]
[]
[null,null,"Summary of Errors"]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"No checks present",null,null,null,{"$f":"HL_Max_Check","v":0}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]