{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["HomePage","Dataset","INDEX-MATCH","Non-Adj","LARGE","AGGREGATE","SUBTOTAL","ADDRESS-MATCH-MAX","MATCH-MAX-ROW","TEXTJOIN","FILTER-MAX","MAX-IF_Single","MAX-IF_Multiple","MAXIFS-INDEX-MATCH","VBA"],"not_rendered":{"charts":0,"images":1,"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":"HomePage","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[8,1,8,14]]}
[]
[]
[]
[]
[]
[]
[null,"How to Find Max Value and Corresponding Cell in Excel"]
[]
[null,"Learn to find max value and corresponding cell reference with this free workbook. Read the article and practice yourself."]
[]
[]
[null,"Prepared By","MD Tanvir Rahman"]
[null,"Last Update","2023-10-08"]
[null,"Reviewed By","A.N.M. Mohaimen Shanto"]
[null,"Article Link","How to Find Max Value and Corresponding Cell in Excel"]
[]
[]
[null,"Methods"]
[null,"1. Using Excel Formula to Find First Max Value and Corresponding Cell"]
[null,"2. Finding Max Value and Corresponding Cell from Multiple Excel Ranges"]
[null,"3. Using Excel Formulas to Find Corresponding Multiple Cells with Max Value"]
[null,"   3.1 Combining TEXTJOIN and IF Functions"]
[null,"   3.2 Merging FILTER, MAX and TEXTJOIN Functions"]
[null,"4. Finding Corresponding Multiple Cells with Max Value Based on Criteria"]
[null,"   4.1 Combining MAX, IF, TEXTJOIN and TEXTSPLIT Functions for Single Criterion"]
[null,"   4.2 Joining MAX, IF, TEXTJOIN and TEXTSPLIT Functions for Multiple Criteria"]
[null,"   4.3 Merging IF, MAXIFS, TEXTJOIN and TEXTSPLIT Functions for Multiple Criteria"]
[null,"5. Using VBA Macro to Find Multiple Maximum Values and Cell Locations"]

{"sheet":"Dataset","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,4],[0,1,0,4]]}
[null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Sample Dataset"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary"]
[null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000]
[null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000]
[null,287,"Kyle Johnson",2019,15000]
[null,452,"Jack Alfred",2020,35000]
[null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page"]

{"sheet":"INDEX-MATCH","index":2,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,19,11,19],[10,20,11,20],[0,14,0,20],[2,14,2,20],[4,19,5,19],[4,20,5,20],[7,19,8,19],[7,20,8,20],[10,6,11,6],[10,7,11,7],[0,1,0,7],[4,6,5,6],[4,7,5,7],[2,1,2,7],[7,6,8,6],[7,7,8,7]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Combining CELL, INDEX, MATCH and MAX Functions",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary",{"$f":"MAX(E6:E18)","v":35000},null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary"]
[null,124,"Morris King",2019,20000,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000,null,null,null,null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary",{"$f":"INDEX(B6:E18,MATCH(MAX(E6:E18),E6:E18,0),2)","v":"Jack Alfred"},null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary"]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000,null,"Cell Location",{"$f":"CELL(\"address\", INDEX(B6:E18, MATCH(MAX(E6:E18), E6:E18, 0),4))","v":"$E$13"},null,null,null,null,null,null,178,"Natasha Marlo",2019,25000,null,"Cell Location"]
[null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,452,"Jack Alfred",2020,35000,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,343,"Alisha Stokes",2019,35000,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,30000,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"Non-Adj","index":3,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[10,20,11,20],[10,21,11,21],[0,15,0,21],[2,15,2,21],[4,20,5,20],[4,21,5,21],[7,20,8,20],[7,21,8,21],[0,1,0,7],[10,6,11,6],[10,7,11,7],[2,1,2,7],[4,6,5,6],[4,7,5,7],[7,6,8,6],[7,7,8,7]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Combining CELL, INDEX, MATCH and MAX Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary",{"$f":"MAX(E6:E12,E15:E20)","v":35000},null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary"]
[null,124,"Morris King",2019,20000,null,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000,null,null,null,null,null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary",{"$f":"INDEX(B6:E20,MATCH(MAX(E6:E12,E15:E20),E6:E20,0),2)","v":"Jack Alfred"},null,null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary"]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000,null,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000,null,"Cell Location",{"$f":"CELL(\"address\",INDEX(B6:E20,MATCH(MAX(E6:E12,E15:E20),E6:E20,0),4))","v":"$E$15"},null,null,null,null,null,null,null,178,"Natasha Marlo",2019,25000,null,"Cell Location"]
[null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,452,"Jack Alfred",2020,35000,null,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,343,"Alisha Stokes",2019,35000,null,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,423,"Benjamin Hick",2020,28000,null,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,452,"Gregory Mills",2017,30000,null,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]
[]
[null,"Go to Home Page"]

{"sheet":"LARGE","index":4,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,20,11,20],[10,21,11,21],[0,15,0,21],[2,15,2,21],[4,20,5,20],[4,21,5,21],[7,20,8,20],[7,21,8,21],[10,6,11,6],[10,7,11,7],[0,1,0,7],[2,1,2,7],[4,6,5,6],[4,7,5,7],[7,6,8,6],[7,7,8,7]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Combining CELL, INDEX, MATCH and LARGE Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary",{"$f":"LARGE(E6:E18,1)","v":35000},null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary"]
[null,124,"Morris King",2019,20000,null,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000,null,null,null,null,null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary",{"$f":"INDEX(B6:E18,MATCH(LARGE(E6:E18,1),E6:E18,0),2)","v":"Jack Alfred"},null,null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary"]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000,null,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000,null,"Cell Location",{"$f":"CELL(\"address\",INDEX(B6:E18,MATCH(LARGE(E6:E18,1),E6:E18,0),4))","v":"$E$13"},null,null,null,null,null,null,null,178,"Natasha Marlo",2019,25000,null,"Cell Location"]
[null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,452,"Jack Alfred",2020,35000,null,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,343,"Alisha Stokes",2019,35000,null,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,30000,null,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"AGGREGATE","index":5,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,20,11,20],[10,21,11,21],[0,15,0,21],[2,15,2,21],[4,20,5,20],[4,21,5,21],[7,20,8,20],[7,21,8,21],[10,6,11,6],[10,7,11,7],[0,1,0,7],[2,1,2,7],[4,6,5,6],[4,7,5,7],[7,6,8,6],[7,7,8,7]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Combining CELL, INDEX, MATCH and AGGREGATE Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary",{"$f":"_xlfn.AGGREGATE(4,6,E6:E18)","v":35000},null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary"]
[null,124,"Morris King",2019,20000,null,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000,null,null,null,null,null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary",{"$f":"INDEX(B6:E18,MATCH(_xlfn.AGGREGATE(4,6,E6:E18),E6:E18,0),2)","v":"Jack Alfred"},null,null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary"]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000,null,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000,null,"Cell Location",{"$f":"CELL(\"address\",INDEX(B6:E18,MATCH(_xlfn.AGGREGATE(4,6,E6:E18),E6:E18,0),4))","v":"$E$13"},null,null,null,null,null,null,null,178,"Natasha Marlo",2019,25000,null,"Cell Location"]
[null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,452,"Jack Alfred",2020,35000,null,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,343,"Alisha Stokes",2019,35000,null,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,30000,null,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"SUBTOTAL","index":6,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,21,11,21],[10,22,11,22],[0,16,0,22],[2,16,2,22],[4,21,5,21],[4,22,5,22],[7,21,8,21],[7,22,8,22],[10,6,11,6],[10,7,11,7],[0,1,0,7],[2,1,2,7],[4,6,5,6],[4,7,5,7],[7,6,8,6],[7,7,8,7]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Combining CELL, INDEX, MATCH and SUBTOTAL Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary",{"$f":"SUBTOTAL(4,E6:E18)","v":35000},null,null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary"]
[null,124,"Morris King",2019,20000,null,null,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000,null,null,null,null,null,null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary",{"$f":"INDEX(B6:E18,MATCH(SUBTOTAL(4,E6:E18),E6:E18,0),2)","v":"Jack Alfred"},null,null,null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary"]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000,null,null,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000,null,"Cell Location",{"$f":"CELL(\"address\",INDEX(B6:E18,MATCH(SUBTOTAL(4,E6:E18),E6:E18,0),4))","v":"$E$13"},null,null,null,null,null,null,null,null,178,"Natasha Marlo",2019,25000,null,"Cell Location"]
[null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,452,"Jack Alfred",2020,35000,null,null,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,343,"Alisha Stokes",2019,35000,null,null,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,30000,null,null,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"ADDRESS-MATCH-MAX","index":7,"n_rows":20,"n_cols":23,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,22,11,22],[10,23,11,23],[0,17,0,23],[2,17,2,23],[4,22,5,22],[4,23,5,23],[7,22,8,22],[7,23,8,23],[10,6,11,6],[10,7,11,7],[0,1,0,7],[2,1,2,7],[4,6,5,6],[4,7,5,7],[7,6,8,6],[7,7,8,7]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Combining ADDRESS, MATCH and MAX Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary",{"$f":"MAX(E6:E18)","v":35000},null,null,null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary"]
[null,124,"Morris King",2019,20000,null,null,null,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000,null,null,null,null,null,null,null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary",{"$f":"INDEX(B6:E18,MATCH(MAX(E6:E18),E6:E18,0),2)","v":"Jack Alfred"},null,null,null,null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary"]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000,null,null,null,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000,null,"Cell Location",{"$f":"ADDRESS(MATCH(MAX(E6:E18), E6:E18, 0) + ROW(E5), 5)","v":"$E$13"},null,null,null,null,null,null,null,null,null,178,"Natasha Marlo",2019,25000,null,"Cell Location"]
[null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,452,"Jack Alfred",2020,35000,null,null,null,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,343,"Alisha Stokes",2019,35000,null,null,null,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,null,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,30000,null,null,null,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,null,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,null,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"MATCH-MAX-ROW","index":8,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,19,11,19],[10,20,11,20],[0,14,0,20],[2,14,2,20],[4,19,5,19],[4,20,5,20],[7,19,8,19],[7,20,8,20],[10,6,11,6],[10,7,11,7],[0,1,0,7],[2,1,2,7],[4,6,5,6],[4,7,5,7],[7,6,8,6],[7,7,8,7]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Using MATCH-MAX Formula Without ADDRESS Function",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary",{"$f":"MAX(E6:E18)","v":35000},null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Max Salary"]
[null,124,"Morris King",2019,20000,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000,null,null,null,null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary",{"$f":"INDEX(B6:E18,MATCH(MAX(E6:E18),E6:E18,0),2)","v":"Jack Alfred"},null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Employee with Maximum Salary"]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000,null,"Cell Location",{"$f":"\"$E$\"&MATCH(MAX(E6:E18),E6:E18,0)+ROW(E5)","v":"$E$13"},null,null,null,null,null,null,178,"Natasha Marlo",2019,25000,null,"Cell Location"]
[null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,452,"Jack Alfred",2020,35000,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,343,"Alisha Stokes",2019,35000,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,30000,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"TEXTJOIN","index":9,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,14,0,20],[2,14,2,20],[4,19,5,19],[4,20,5,20],[7,19,8,19],[7,20,8,20],[0,1,0,7],[2,1,2,7],[4,6,5,6],[4,7,5,7],[7,6,8,6],[7,7,8,7]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Combining TEXTJOIN and IF Functions",null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Employee with Maximum Salary",{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF(E6:E18=MAX(E6:E18), C6:C18, \"\"))","v":"Jack Alfred, Alisha Stokes"},null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Employee with Maximum Salary"]
[null,124,"Morris King",2019,20000,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000,null,null,null,null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000,null,"Cell Location",{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF(E6:E18=MAX(E6:E18), \"E\" & ROW(E6:E18), \"\"))","v":"E13, E14"},null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Cell Location"]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000,null,null,null,null,null,null,null,null,null,178,"Natasha Marlo",2019,25000]
[null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,452,"Jack Alfred",2020,35000,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,343,"Alisha Stokes",2019,35000,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,30000,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"FILTER-MAX","index":10,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,15,0,21],[2,15,2,21],[4,20,5,20],[4,21,5,21],[7,20,8,20],[7,21,8,21],[0,1,0,8],[4,8,5,8],[6,8,7,8],[2,1,2,8],[4,6,5,6]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Combining FILTER and MAX Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Employee with Maximum Salary",null,"Cell Location",null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Employee with Maximum Salary"]
[null,124,"Morris King",2019,20000,null,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,54,"John Smith",2020,25000,null,{"$f":"_xlfn._xlws.FILTER(C6:C18,E6:E18=MAX(E6:E18))","v":"Jack Alfred"},null,{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF(E6:E18=MAX(E6:E18), \"E\" & ROW(C6:C18), \"\"))","v":"E13, E14"},null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,231,"Stephen Dulbarg",2019,25000,null,"Alisha Stokes",null,null,null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Cell Location"]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,101,"Steve Moor",2021,28000,null,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,178,"Natasha Marlo",2019,25000,null,null,null,null,null,null,null,null,null,null,178,"Natasha Marlo",2019,25000]
[null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,452,"Jack Alfred",2020,35000,null,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,343,"Alisha Stokes",2019,35000,null,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,30000,null,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"MAX-IF_Single","index":11,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,7],[2,1,2,7],[6,6,7,6],[6,7,7,7],[0,11,0,17],[2,11,2,17],[4,16,5,16],[4,17,5,17],[7,16,8,16],[7,17,8,17]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,{"$f":"_xlfn._xlws.SORT(D6:D18,1)","v":2016}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,"Combining MAX,IF, TEXTJOIN, TEXTSPLIT Functions",null,null,null,null,null,null,null,null,null,"Practice Section",null,null,null,null,null,null,null,null,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Joining Year >",2018,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Employee with Maximum Salary",null,null,null,2019]
[null,124,"Morris King",2019,65000,null,null,null,null,null,null,124,"Morris King",2019,20000,null,null,null,null,null,2019]
[null,54,"John Smith",2023,65000,null,"Employee\n(Max Salary)","Cell Location",null,null,null,54,"John Smith",2020,25000,null,null,null,null,null,2019]
[null,231,"Stephen Dulbarg",2018,65000,null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Cell Location",null,null,null,2019]
[null,432,"Usman Khaja",2018,18000,null,{"$f":"IFERROR(_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\", TRUE,IF((D6:D18 > H5)*(E6:E18 = MAX(IF(D6:D18 > H5, E6:E18))), C6:C18, \"\"),),,\",\"),\"\")","v":"Morris King"},{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G9, $C$6:$C$18, 0),1)),\"\")","v":"$E$6"},null,null,null,432,"Usman Khaja",2018,18000,null,null,null,null,null,2020]
[null,101,"Steve Moor",2021,65000,null,"John Smith",{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G10, $C$6:$C$18, 0),1)),\"\")","v":"$E$7"},null,null,null,101,"Steve Moor",2021,28000,null,null,null,null,null,2021]
[null,178,"Natasha Marlo",2019,25000,null,"Steve Moor",{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G11, $C$6:$C$18, 0),1)),\"\")","v":"$E$10"},null,null,null,178,"Natasha Marlo",2019,25000,null,null,null,null,null,2021]
[null,287,"Kyle Johnson",2019,15000,null,"Jack Alfred",{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G12, $C$6:$C$18, 0),1)),\"\")","v":"$E$13"},null,null,null,287,"Kyle Johnson",2019,15000,null,null,null,null,null,2021]
[null,452,"Jack Alfred",2021,65000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G13, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,452,"Jack Alfred",2020,35000,null,null,null,null,null,2023]
[null,343,"Alisha Stokes",2019,35000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G14, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G15, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,60000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G16, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G17, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G18, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"MAX-IF_Multiple","index":12,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,7],[2,1,2,7],[7,7,8,7],[7,6,8,6],[0,12,0,18],[2,12,2,18],[4,17,5,17],[4,18,5,18],[7,17,8,17],[7,18,8,18]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,{"$f":"_xlfn._xlws.SORT(D6:D18,1)","v":2016}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,"Combining MAX,IF, TEXTJOIN, TEXTSPLIT Functions",null,null,null,null,null,null,null,null,null,null,"Practice Section",null,null,null,null,null,null,null,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Joining Year >=",2020,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Employee with Maximum Salary",null,null,2019]
[null,124,"Morris King",2019,65000,null,"Joining Year <=",2023,null,null,null,null,124,"Morris King",2019,20000,null,null,null,null,2019]
[null,54,"John Smith",2023,65000,null,null,null,null,null,null,null,54,"John Smith",2020,25000,null,null,null,null,2019]
[null,231,"Stephen Dulbarg",2018,65000,null,"Employee\n(Max Salary)","Cell Location",null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Cell Location",null,null,2019]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000,null,null,null,null,2020]
[null,101,"Steve Moor",2021,65000,null,{"$f":"IFERROR(_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\", TRUE, IF((D6:D18 >=H5)*(D6:D18 <=H6), IF(E6:E18 = MAX(IF((D6:D18 >=H5)*(D6:D18 <=H6), E6:E18)), C6:C18, \"\"), \"\"),),,\",\"),\"\")","v":"John Smith"},{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G10, $C$6:$C$18, 0),1)),\"\")","v":"$E$7"},null,null,null,null,101,"Steve Moor",2021,28000,null,null,null,null,2021]
[null,178,"Natasha Marlo",2019,25000,null,"Steve Moor",{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G11, $C$6:$C$18, 0),1)),\"\")","v":"$E$10"},null,null,null,null,178,"Natasha Marlo",2019,25000,null,null,null,null,2021]
[null,287,"Kyle Johnson",2019,15000,null,"Jack Alfred",{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G12, $C$6:$C$18, 0),1)),\"\")","v":"$E$13"},null,null,null,null,287,"Kyle Johnson",2019,15000,null,null,null,null,2021]
[null,452,"Jack Alfred",2021,65000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G13, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,452,"Jack Alfred",2020,35000,null,null,null,null,2023]
[null,343,"Alisha Stokes",2019,35000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G14, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G15, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,60000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G16, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G17, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G18, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"MAXIFS-INDEX-MATCH","index":13,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,7],[2,1,2,7],[7,6,8,6],[7,7,8,7],[0,12,0,18],[2,12,2,18],[4,17,5,17],[4,18,5,18],[7,17,8,17],[7,18,8,18]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,{"$f":"_xlfn._xlws.SORT(D6:D18,1)","v":2016}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,"Combining IF, MAXIFS, TEXTJOIN and TEXTSPLIT Functions",null,null,null,null,null,null,null,null,null,null,"Practice Section",null,null,null,null,null,null,null,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,"Employee ID","Employee Name","Joining Year","Salary",null,"Joining Year >=",2020,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Employee with Maximum Salary",null,null,2019]
[null,124,"Morris King",2019,65000,null,"Joining Year <=",2023,null,null,null,null,124,"Morris King",2019,20000,null,null,null,null,2019]
[null,54,"John Smith",2023,65000,null,null,null,null,null,null,null,54,"John Smith",2020,25000,null,null,null,null,2019]
[null,231,"Stephen Dulbarg",2018,65000,null,"Employee\n(Max Salary)","Cell Location",null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Cell Location",null,null,2019]
[null,432,"Usman Khaja",2018,18000,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000,null,null,null,null,2020]
[null,101,"Steve Moor",2021,65000,null,{"$f":"IFERROR(_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\", TRUE, IF((D6:D18 >=H5)*(D6:D18 <=H6), IF(E6:E18 =_xlfn.MAXIFS(E6:E18, D6:D18, \">=\"&H5, D6:D18, \"<=\"&H6), C6:C18, \"\"), \"\")),,\",\"),\"\")","v":"John Smith"},{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G10, $C$6:$C$18, 0),1)),\"\")","v":"$E$7"},null,null,null,null,101,"Steve Moor",2021,28000,null,null,null,null,2021]
[null,178,"Natasha Marlo",2019,25000,null,"Steve Moor",{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G11, $C$6:$C$18, 0),1)),\"\")","v":"$E$10"},null,null,null,null,178,"Natasha Marlo",2019,25000,null,null,null,null,2021]
[null,287,"Kyle Johnson",2019,15000,null,"Jack Alfred",{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G12, $C$6:$C$18, 0),1)),\"\")","v":"$E$13"},null,null,null,null,287,"Kyle Johnson",2019,15000,null,null,null,null,2021]
[null,452,"Jack Alfred",2021,65000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G13, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,452,"Jack Alfred",2020,35000,null,null,null,null,2023]
[null,343,"Alisha Stokes",2019,35000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G14, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,423,"Benjamin Hick",2020,28000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G15, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,452,"Gregory Mills",2017,60000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G16, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,452,"Gregory Mills",2017,30000]
[null,554,"Kane Simpson",2016,20000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G17, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,554,"Kane Simpson",2016,20000]
[null,99,"Irfan Khan",2021,25000,null,null,{"$f":"IFERROR(CELL(\"address\",INDEX($E$6:$E$18, MATCH(G18, $C$6:$C$18, 0),1)),\"\")","v":""},null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]

{"sheet":"VBA","index":14,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,15,0,21],[2,15,2,21],[4,20,5,20],[4,21,5,21],[7,20,8,20],[7,21,8,21],[7,7,8,7],[7,6,8,6],[0,1,0,7],[2,1,2,7],[4,6,5,6],[4,7,5,7]]}
[null,"Excel Find Max Value and Corresponding Cell",null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel Find Max Value and Corresponding Cell"]
[]
[null,"Using VBA Macro",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Set 1","Set 2","Set 3","Set 4",null,"Max Number",120,null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Year","Salary",null,"Employee with Maximum Salary"]
[null,119,48,108,97,null,null,null,null,null,null,null,null,null,null,124,"Morris King",2019,20000]
[null,74,92,81,87,null,null,null,null,null,null,null,null,null,null,54,"John Smith",2020,25000]
[null,80,82,61,120,null,"Cell Locations","$E$8, $E$10, $C$16",null,null,null,null,null,null,null,231,"Stephen Dulbarg",2019,25000,null,"Cell Location"]
[null,27,70,69,82,null,null,null,null,null,null,null,null,null,null,432,"Usman Khaja",2018,18000]
[null,29,93,71,120,null,null,null,null,null,null,null,null,null,null,101,"Steve Moor",2021,28000]
[null,104,38,29,102,null,null,null,null,null,null,null,null,null,null,178,"Natasha Marlo",2019,25000]
[null,20,19,104,45,null,null,null,null,null,null,null,null,null,null,287,"Kyle Johnson",2019,15000]
[null,41,111,41,102,null,null,null,null,null,null,null,null,null,null,452,"Jack Alfred",2020,35000]
[null,18,60,21,60,null,null,null,null,null,null,null,null,null,null,343,"Alisha Stokes",2019,35000]
[null,29,16,76,87,null,null,null,null,null,null,null,null,null,null,423,"Benjamin Hick",2020,28000]
[null,102,120,66,43,null,null,null,null,null,null,null,null,null,null,452,"Gregory Mills",2017,30000]
[null,41,28,88,78,null,null,null,null,null,null,null,null,null,null,554,"Kane Simpson",2016,20000]
[null,57,82,113,97,null,null,null,null,null,null,null,null,null,null,99,"Irfan Khan",2021,25000]
[]
[null,"Go to Home Page",null,null,null,null,null,null,null,null,null,null,null,null,null,"Go to Home Page"]