{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Dataset","Max","SUMPRODUCT","INDEX","LOOKUP","MATCH","VBA","Practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"Sample Dataset","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Last Row with Specific Value"]
[]
[null,"Customer Name","Gender","Loan Purpose","Job","Credit Risk"]
[null,"Catherine","Female","House","Actor","Low"]
[null,"Almanda","Female","Car","Lawyer","Low"]
[null,"Jacob","Male","Furniture","Doctor","Low"]
[null,"Taylor","Male","Land","Doctor","High"]
[null,"Snoop","Male","House","Singer","Low"]
[null,"Snoop","Male","Business","Singer","Low"]
[null,"Kylie","Female","Business","Model","High"]
[null,"Longstaff","Male","Car","Actor","Low"]
[null,"Tensison","Male","Furniture","Architect","Low"]
[null,"Almanda","Female","House","Lawyer","High"]
[null,"Catherine","Female","Land","Actor","Very High"]

{"sheet":"Max","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Last Row with Specific Value"]
[]
[null,"Customer","Gender","Loan Purpose","Job","Credit Risk",null,"Customer","Last Row"]
[null,"Catherine","Female","House","Actor","Low",null,"Catherine",{"$f":"MAX(IF($B$5:$B$15=H5,ROW($B$5:$B$15)))","v":15}]
[null,"Almanda","Female","Car","Lawyer","Low",null,"Almanda",{"$f":"MAX(IF($B$5:$B$15=H6,ROW($B$5:$B$15)))","v":14}]
[null,"Jacob","Male","Furniture","Doctor","Low",null,"Jacob",{"$f":"MAX(IF($B$5:$B$15=H7,ROW($B$5:$B$15)))","v":7}]
[null,"Taylor","Male","Land","Doctor","High",null,"Taylor",{"$f":"MAX(IF($B$5:$B$15=H8,ROW($B$5:$B$15)))","v":8}]
[null,"Snoop","Male","House","Singer","Low",null,"Snoop",{"$f":"MAX(IF($B$5:$B$15=H9,ROW($B$5:$B$15)))","v":10}]
[null,"Snoop","Male","Business","Singer","Low",null,"Kylie",{"$f":"MAX(IF($B$5:$B$15=H10,ROW($B$5:$B$15)))","v":11}]
[null,"Kylie","Female","Business","Model","High",null,"Longstaff",{"$f":"MAX(IF($B$5:$B$15=H11,ROW($B$5:$B$15)))","v":12}]
[null,"Longstaff","Male","Car","Actor","Low",null,"Tensison",{"$f":"MAX(IF($B$5:$B$15=H12,ROW($B$5:$B$15)))","v":13}]
[null,"Tensison","Male","Furniture","Architect","Low"]
[null,"Almanda","Female","House","Lawyer","High"]
[null,"Catherine","Female","Land","Actor","Very High"]

{"sheet":"SUMPRODUCT","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Last Row with Specific Value"]
[]
[null,"Customer","Gender","Loan Purpose","Job","Credit Risk",null,"Customer","Last Row"]
[null,"Catherine","Female","House","Actor","Low",null,"Catherine",{"$f":"SUMPRODUCT(MAX(ROW(B5:F15)*(B5:B15=H5)))","v":15}]
[null,"Almanda","Female","Car","Lawyer","Low",null,"Almanda",{"$f":"SUMPRODUCT(MAX(ROW(B6:F16)*(B6:B16=H6)))","v":14}]
[null,"Jacob","Male","Furniture","Doctor","Low",null,"Jacob",{"$f":"SUMPRODUCT(MAX(ROW(B7:F17)*(B7:B17=H7)))","v":7}]
[null,"Taylor","Male","Land","Doctor","High",null,"Taylor",{"$f":"SUMPRODUCT(MAX(ROW(B8:F18)*(B8:B18=H8)))","v":8}]
[null,"Snoop","Male","House","Singer","Low",null,"Snoop",{"$f":"SUMPRODUCT(MAX(ROW(B9:F19)*(B9:B19=H9)))","v":10}]
[null,"Snoop","Male","Business","Singer","Low",null,"Kylie",{"$f":"SUMPRODUCT(MAX(ROW(B10:F20)*(B10:B20=H10)))","v":11}]
[null,"Kylie","Female","Business","Model","High",null,"Longstaff",{"$f":"SUMPRODUCT(MAX(ROW(B11:F21)*(B11:B21=H11)))","v":12}]
[null,"Longstaff","Male","Car","Actor","Low",null,"Tensison",{"$f":"SUMPRODUCT(MAX(ROW(B12:F22)*(B12:B22=H12)))","v":13}]
[null,"Tensison","Male","Furniture","Architect","Low"]
[null,"Almanda","Female","House","Lawyer","High"]
[null,"Catherine","Female","Land","Actor","Very High"]

{"sheet":"INDEX","index":3,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Last Row with Specific Value"]
[]
[null,"Customer","Gender","Loan Purpose","Job","Credit Risk",null,"Customer","Last Row"]
[null,"Catherine","Female","House","Actor","Low",null,"Catherine",{"$f":"INDEX($F$5:$F$15,SUMPRODUCT(MAX(ROW($B$5:$B$15)*(H5=$B$5:$B$15))-4))","v":"Very High"}]
[null,"Almanda","Female","Car","Lawyer","Low",null,"Almanda",{"$f":"INDEX($F$5:$F$15,SUMPRODUCT(MAX(ROW($B$5:$B$15)*(H6=$B$5:$B$15))-4))","v":"High"}]
[null,"Jacob","Male","Furniture","Doctor","Low",null,"Jacob","Low"]
[null,"Taylor","Male","Land","Doctor","High",null,"Taylor","High"]
[null,"Snoop","Male","House","Singer","Low",null,"Snoop","Low"]
[null,"Snoop","Male","Business","Singer","Low",null,"Kylie","High"]
[null,"Kylie","Female","Business","Model","High",null,"Longstaff","Low"]
[null,"Longstaff","Male","Car","Actor","Low",null,"Tensison","Low"]
[null,"Tensison","Male","Furniture","Architect","Low"]
[null,"Almanda","Female","House","Lawyer","High"]
[null,"Catherine","Female","Land","Actor","Very High"]

{"sheet":"LOOKUP","index":4,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Last Row with Specific Value"]
[]
[null,"Customer","Gender","Loan Purpose","Job","Credit Risk",null,"Customer","Last Row"]
[null,"Catherine","Female","House","Actor","Low",null,"Catherine",{"$f":"LOOKUP(2,1/($B$5:$B$15=H5),$F$5:$F$15)","v":"Very High"}]
[null,"Almanda","Female","Car","Lawyer","Low",null,"Almanda",{"$f":"LOOKUP(2,1/($B$5:$B$15=H6),$F$5:$F$15)","v":"High"}]
[null,"Jacob","Male","Furniture","Doctor","Low",null,"Jacob","Low"]
[null,"Taylor","Male","Land","Doctor","High",null,"Taylor","High"]
[null,"Snoop","Male","House","Singer","Low",null,"Snoop","Low"]
[null,"Snoop","Male","Business","Singer","Low",null,"Kylie","High"]
[null,"Kylie","Female","Business","Model","High",null,"Longstaff","Low"]
[null,"Longstaff","Male","Car","Actor","Low",null,"Tensison","Low"]
[null,"Tensison","Male","Furniture","Architect","Low"]
[null,"Almanda","Female","House","Lawyer","High"]
[null,"Catherine","Female","Land","Actor","Very High"]

{"sheet":"MATCH","index":5,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Last Row with Specific Value"]
[]
[null,"Customer","Gender","Loan Purpose","Job","Credit Risk",null,"Customer","Last Row"]
[null,"Catherine","Female","House","Actor","Low",null,"Catherine",{"$f":"INDEX($F$5:$F$15,MATCH(2,1/($B$5:$B$15=H5)))","v":"Very High"}]
[null,"Almanda","Female","Car","Lawyer","Low",null,"Almanda",{"$f":"INDEX($F$5:$F$15,MATCH(2,1/($B$5:$B$15=H6)))","v":"High"}]
[null,"Jacob","Male","Furniture","Doctor","Low",null,"Jacob",{"$f":"INDEX($F$5:$F$15,MATCH(2,1/($B$5:$B$15=H7)))","v":"Low"}]
[null,"Taylor","Male","Land","Doctor","High",null,"Taylor",{"$f":"INDEX($F$5:$F$15,MATCH(2,1/($B$5:$B$15=H8)))","v":"High"}]
[null,"Snoop","Male","House","Singer","Low",null,"Snoop",{"$f":"INDEX($F$5:$F$15,MATCH(2,1/($B$5:$B$15=H9)))","v":"Low"}]
[null,"Snoop","Male","Business","Singer","Low",null,"Kylie",{"$f":"INDEX($F$5:$F$15,MATCH(2,1/($B$5:$B$15=H10)))","v":"High"}]
[null,"Kylie","Female","Business","Model","High",null,"Longstaff",{"$f":"INDEX($F$5:$F$15,MATCH(2,1/($B$5:$B$15=H11)))","v":"Low"}]
[null,"Longstaff","Male","Car","Actor","Low",null,"Tensison",{"$f":"INDEX($F$5:$F$15,MATCH(2,1/($B$5:$B$15=H12)))","v":"Low"}]
[null,"Tensison","Male","Furniture","Architect","Low"]
[null,"Almanda","Female","House","Lawyer","High"]
[null,"Catherine","Female","Land","Actor","Very High"]

{"sheet":"VBA","index":6,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Last Row with Specific Value"]
[]
[null,"Customer","Gender","Loan Purpose","Job","Credit Risk",null,"Customer","Last Row"]
[null,"Catherine","Female","House","Actor","Low",null,"Catherine",{"$f":"MylastrowFunction(H5,B5:F15,5)","v":"Very High"}]
[null,"Almanda","Female","Car","Lawyer","Low",null,"Almanda",{"$f":"MylastrowFunction(H6,B6:F16,5)","v":"High"}]
[null,"Jacob","Male","Furniture","Doctor","Low",null,"Jacob",{"$f":"MylastrowFunction(H7,B7:F17,5)","v":"Low"}]
[null,"Taylor","Male","Land","Doctor","High",null,"Taylor",{"$f":"MylastrowFunction(H8,B8:F18,5)","v":"High"}]
[null,"Snoop","Male","House","Singer","Low",null,"Snoop",{"$f":"MylastrowFunction(H9,B9:F19,5)","v":"Low"}]
[null,"Snoop","Male","Business","Singer","Low",null,"Kylie",{"$f":"MylastrowFunction(H10,B10:F20,5)","v":"High"}]
[null,"Kylie","Female","Business","Model","High",null,"Longstaff",{"$f":"MylastrowFunction(H11,B11:F21,5)","v":"Low"}]
[null,"Longstaff","Male","Car","Actor","Low",null,"Tensison",{"$f":"MylastrowFunction(H12,B12:F22,5)","v":"Low"}]
[null,"Tensison","Male","Furniture","Architect","Low"]
[null,"Almanda","Female","House","Lawyer","High"]
[null,"Catherine","Female","Land","Actor","Very High"]

{"sheet":"Practice","index":7,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Practice Here"]
[]
[null,"Customer","Gender","Loan Purpose","Job","Credit Risk"]
[null,"Catherine","Female","House","Actor","Low"]
[null,"Almanda","Female","Car","Lawyer","Low"]
[null,"Jacob","Male","Furniture","Doctor","Low"]
[null,"Taylor","Male","Land","Doctor","High"]
[null,"Snoop","Male","House","Singer","Low"]
[null,"Snoop","Male","Business","Singer","Low"]
[null,"Kylie","Female","Business","Model","High"]
[null,"Longstaff","Male","Car","Actor","Low"]
[null,"Tensison","Male","Furniture","Architect","Low"]
[null,"Almanda","Female","House","Lawyer","High"]
[null,"Catherine","Female","Land","Actor","Very High"]