{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset 1","MATCH Function","COLUMN Function","SUBSTITUTE Function","VBA Code","Dataset 2","Excel Table","Dataset 3","INDEX AND MATCH Functions"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Dataset 1","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sales Performance"]
[]
[null,"Name","Sales"]
[null,"Sam",2435]
[null,"Adam",4025]
[null,"Anna",4767]
[null,"Harry",4533]
[null,"Tyler",1591]
[null,"Will",3660]
[null,"Smith",2092]
[null,"Julie",2914]
[null,"Gloria",2652]
[null,"Mary",1096]

{"sheet":"MATCH Function","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using MATCH Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Sales",null,"Column Name","Column Number",null,null,null,null,null,"Name","Sales",null,"Column Name","Column Number"]
[null,"Sam",2435,null,"Sales",{"$f":"MATCH(E5,$4:$4,0)","v":3},null,null,null,null,null,"Sam",2435,null,"Sales"]
[null,"Adam",4025,null,"Name",{"$f":"MATCH(E6,$4:$4,0)","v":2},null,null,null,null,null,"Adam",4025,null,"Name"]
[null,"Anna",4767,null,null,null,null,null,null,null,null,"Anna",4767]
[null,"Harry",4533,null,null,null,null,null,null,null,null,"Harry",4533]
[null,"Tyler",1591,null,null,null,null,null,null,null,null,"Tyler",1591]
[null,"Will",3660,null,null,null,null,null,null,null,null,"Will",3660]
[null,"Smith",2092,null,null,null,null,null,null,null,null,"Smith",2092]
[null,"Julie",2914,null,null,null,null,null,null,null,null,"Julie",2914]
[null,"Gloria",2652,null,null,null,null,null,null,null,null,"Gloria",2652]
[null,"Mary",1096,null,null,null,null,null,null,null,null,"Mary",1096]

{"sheet":"COLUMN Function","index":2,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using COLUMN Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Sales",null,"Column Name","Column Number",null,null,null,null,null,"Name","Sales",null,"Column Name","Column Number"]
[null,"Sam",2435,null,"Sales",{"$f":"COLUMN(C4)","v":3},null,null,null,null,null,"Sam",2435,null,"Sales"]
[null,"Adam",4025,null,"Name",{"$f":"COLUMN(B4)","v":2},null,null,null,null,null,"Adam",4025,null,"Name"]
[null,"Anna",4767,null,null,null,null,null,null,null,null,"Anna",4767]
[null,"Harry",4533,null,null,null,null,null,null,null,null,"Harry",4533]
[null,"Tyler",1591,null,null,null,null,null,null,null,null,"Tyler",1591]
[null,"Will",3660,null,null,null,null,null,null,null,null,"Will",3660]
[null,"Smith",2092,null,null,null,null,null,null,null,null,"Smith",2092]
[null,"Julie",2914,null,null,null,null,null,null,null,null,"Julie",2914]
[null,"Gloria",2652,null,null,null,null,null,null,null,null,"Gloria",2652]
[null,"Mary",1096,null,null,null,null,null,null,null,null,"Mary",1096]

{"sheet":"SUBSTITUTE Function","index":3,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using SUBSTITUTE Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Sales",null,"Column Name","Column Letter",null,null,null,null,null,"Name","Sales",null,"Column Name","Column Number"]
[null,"Sam",2435,null,"Sales",{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(C4),4),\"1\",\"\")","v":"C"},null,null,null,null,null,"Sam",2435,null,"Sales"]
[null,"Adam",4025,null,"Name",{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(B4),4),\"1\",\"\")","v":"B"},null,null,null,null,null,"Adam",4025,null,"Name"]
[null,"Anna",4767,null,null,null,null,null,null,null,null,"Anna",4767]
[null,"Harry",4533,null,null,null,null,null,null,null,null,"Harry",4533]
[null,"Tyler",1591,null,null,null,null,null,null,null,null,"Tyler",1591]
[null,"Will",3660,null,null,null,null,null,null,null,null,"Will",3660]
[null,"Smith",2092,null,null,null,null,null,null,null,null,"Smith",2092]
[null,"Julie",2914,null,null,null,null,null,null,null,null,"Julie",2914]
[null,"Gloria",2652,null,null,null,null,null,null,null,null,"Gloria",2652]
[null,"Mary",1096,null,null,null,null,null,null,null,null,"Mary",1096]

{"sheet":"VBA Code","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Name","Sales"]
[null,"Sam",2435]
[null,"Adam",4025]
[null,"Anna",4767]
[null,"Harry",4533]
[null,"Tyler",1591]
[null,"Will",3660]
[null,"Smith",2092]
[null,"Julie",2914]
[null,"Gloria",2652]
[null,"Mary",1096]

{"sheet":"Dataset 2","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"List of Clients"]
[]
[null,"Company Name","Address","City","State","Zip Code"]
[null,"Stella","1025 Us Highway 19","Port Richey","FL",73259]
[null,"Archer Construction","950 Us Highway 1","Saginaw","MI",34261]
[null,"CONFIDENCE Imports","466 NE 70th St","Seattle","WA",98115]
[null,"M3 Inc.","485 N Freedom Blvd","Provo","UT",84601]
[null,"Dauntless USA","7743 Montego Rd","San Antonio","TX",78250]
[null,"Eleanor Salon","1331 W Paradise Dr","West Bend","WV",53095]
[null,"Bison Sports","680 Old Mill Rd","Millersville","MD",21108]
[null,"Warton Finances","3323 Thomasville Rd","Tallahassee","FL",23461]
[null,"Prime Real Estates Inc.","5113 W Western Ave","Soth Bend","IA",46619]
[null,"W2 Corporation","410 W James Lee Blvd","Crestview","FL",32526]

{"sheet":"Excel Table","index":6,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Excel Table"]
[]
[null,"Company Name","Address","City","State","Zip Code"]
[null,"Stella","1025 Us Highway 19","Port Richey","FL",73259]
[null,"Archer Construction","950 Us Highway 1","Saginaw","MI",34261]
[null,"CONFIDENCE Imports","466 NE 70th St","Seattle","WA",98115]
[null,"M3 Inc.","485 N Freedom Blvd","Provo","UT",84601]
[null,"Dauntless USA","7743 Montego Rd","San Antonio","TX",78250]
[null,"Eleanor Salon","1331 W Paradise Dr","West Bend","WV",53095]
[null,"Bison Sports","680 Old Mill Rd","Millersville","MD",21108]
[null,"Warton Finances","3323 Thomasville Rd","Tallahassee","FL",23461]
[null,"Prime Real Estates Inc.","5113 W Western Ave","Soth Bend","IA",46619]
[null,"W2 Corporation","410 W James Lee Blvd","Crestview","FL",32526]
[]
[null,"Column Name","Column Number"]
[null,"Company Name",{"$f":"MATCH(B17,Clients_List[#Headers],0)","v":1}]
[null,"Address",{"$f":"MATCH(B18,Clients_List[#Headers],0)","v":2}]
[null,"City",{"$f":"MATCH(B19,Clients_List[#Headers],0)","v":3}]
[null,"State",{"$f":"MATCH(B20,Clients_List[#Headers],0)","v":4}]
[null,"Zip Code",{"$f":"MATCH(B21,Clients_List[#Headers],0)","v":5}]

{"sheet":"Dataset 3","index":7,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,2,3,8]]}
[]
[null,"Marks Distribution"]
[]
[null,null,"Student Name"]
[null,"Subject","Zoe","Ana","Michell","Patrick","John","Lucy","Judy"]
[null,"Physics",82,45,86,49,92,57,77]
[null,"Chemistry",62,85,88,60,73,76,82]
[null,"Biology",51,66,80,76,84,93,97]
[null,"Maths",74,82,50,59,52,62,89]

{"sheet":"INDEX AND MATCH Functions","index":8,"n_rows":14,"n_cols":21,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,13,1,20],[3,14,3,20],[11,14,11,15],[12,14,12,15],[13,14,13,15],[11,2,11,3],[12,2,12,3],[13,2,13,3],[3,2,3,8],[1,1,1,8]]}
[]
[null,"Using INDEX AND MATCH Functions",null,null,null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,null,"Student Name",null,null,null,null,null,null,null,null,null,null,null,"Student Name"]
[null,"Subject","Zoe","Ana","Michell","Patrick","John","Lucy","Judy",null,null,null,null,"Subject","Zoe","Ana","Michell","Patrick","John","Lucy","Judy"]
[null,"Physics",82,45,86,49,92,57,77,null,null,null,null,"Physics",82,45,86,49,92,57,77]
[null,"Chemistry",62,85,88,60,73,76,82,null,null,null,null,"Chemistry",62,85,88,60,73,76,82]
[null,"Biology",51,66,80,76,84,93,97,null,null,null,null,"Biology",51,66,80,76,84,93,97]
[null,"Maths",74,82,50,59,52,62,89,null,null,null,null,"Maths",74,82,50,59,52,62,89]
[]
[]
[null,"Subject","Physics",null,null,null,null,null,null,null,null,null,null,"Subject"]
[null,"Student Name","Patrick",null,null,null,null,null,null,null,null,null,null,"Student Name"]
[null,"Marks",{"$f":"INDEX(C6:I9,MATCH(C12,B6:B9,0),MATCH(C13,C5:I5,0))","v":49},null,null,null,null,null,null,null,null,null,null,"Marks"]