{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Sort & Filter"," SORT Function","SORTBY Function","SORTBY For Months","SORTBY For Days","SORTBY For Years","SORTBY For Months and Days","INDEX-MATCH-RANK","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sorting by Date in Excel"]
[]
[null,"Employee ID","Employee Name","Joining Date"]
[null,213,"Frank Orwell","2009-11-18"]
[null,157,"Alfred Moyes","2010-04-09"]
[null,285,"Shane Williams","2009-08-30"]
[null,429,"Kane Austin","2011-10-06"]
[null,294,"Ricky Ben","2014-08-17"]
[null,239,"Natalia Marlo","2015-12-30"]
[null,103,"Usman Malik","2015-01-09"]
[null,154,"Jennifer Hick","2012-01-01"]
[null,472,"Steve Smith","2014-02-22"]
[null,381,"Richard Simpson","2015-11-03"]
[null,371,"Matthew Shepherd","2014-11-14"]
[null,186,"Gregory Austin","2011-06-24"]
[null,250,"Marcus North","2016-08-09"]
[null,304,"Peter Boon","2008-03-30"]
[null,303,"Kevin Moor","2010-11-02"]
[null,128,"Jack Moyes","2010-07-19"]

{"sheet":"Sort & Filter","index":1,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,13,1,15]]}
[]
[null,"Applying Sort & Filter Feature",null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<< "]
[]
[null,"Employee ID","Employee Name","Joining Date",null,null,null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Date"]
[null,304,"Peter Boon","2008-03-30",null,null,null,null,null,null,null,null,null,213,"Frank Orwell","2009-11-18"]
[null,285,"Shane Williams","2009-08-30",null,null,null,null,null,null,null,null,null,157,"Alfred Moyes","2010-04-09"]
[null,213,"Frank Orwell","2009-11-18",null,null,null,null,null,null,null,null,null,285,"Shane Williams","2009-08-30"]
[null,157,"Alfred Moyes","2010-04-09",null,null,null,null,null,null,null,null,null,429,"Kane Austin","2011-10-06"]
[null,128,"Jack Moyes","2010-07-19",null,null,null,null,null,null,null,null,null,294,"Ricky Ben","2014-08-17"]
[null,303,"Kevin Moor","2010-11-02",null,null,null,null,null,null,null,null,null,239,"Natalia Marlo","2015-12-30"]
[null,186,"Gregory Austin","2011-06-24",null,null,null,null,null,null,null,null,null,103,"Usman Malik","2015-01-09"]
[null,429,"Kane Austin","2011-10-06",null,null,null,null,null,null,null,null,null,154,"Jennifer Hick","2012-01-01"]
[null,154,"Jennifer Hick","2012-01-01",null,null,null,null,null,null,null,null,null,472,"Steve Smith","2014-02-22"]
[null,472,"Steve Smith","2014-02-22",null,null,null,null,null,null,null,null,null,381,"Richard Simpson","2015-11-03"]
[null,294,"Ricky Ben","2014-08-17",null,null,null,null,null,null,null,null,null,371,"Matthew Shepherd","2014-11-14"]
[null,371,"Matthew Shepherd","2014-11-14",null,null,null,null,null,null,null,null,null,186,"Gregory Austin","2011-06-24"]
[null,103,"Usman Malik","2015-01-09",null,null,null,null,null,null,null,null,null,250,"Marcus North","2016-08-09"]
[null,381,"Richard Simpson","2015-11-03",null,null,null,null,null,null,null,null,null,304,"Peter Boon","2008-03-30"]
[null,239,"Natalia Marlo","2015-12-30",null,null,null,null,null,null,null,null,null,303,"Kevin Moor","2010-11-02"]
[null,250,"Marcus North","2016-08-09",null,null,null,null,null,null,null,null,null,128,"Jack Moyes","2010-07-19"]

{"sheet":" SORT Function","index":2,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7],[1,14,1,16]]}
[]
[null,"Using SORT Function",null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<< "]
[]
[null,"Employee ID","Employee Name","Joining Date",null,"Sorted by Date",null,null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Date"]
[null,213,"Frank Orwell","2009-11-18",null,{"$f":"_xlfn._xlws.SORT(B5:D20,3,1,FALSE)","v":304},"Peter Boon","2008-03-30",null,null,null,null,null,null,213,"Frank Orwell","2009-11-18"]
[null,157,"Alfred Moyes","2010-04-09",null,285,"Shane Williams","2009-08-30",null,null,null,null,null,null,157,"Alfred Moyes","2010-04-09"]
[null,285,"Shane Williams","2009-08-30",null,213,"Frank Orwell","2009-11-18",null,null,null,null,null,null,285,"Shane Williams","2009-08-30"]
[null,429,"Kane Austin","2011-10-06",null,157,"Alfred Moyes","2010-04-09",null,null,null,null,null,null,429,"Kane Austin","2011-10-06"]
[null,294,"Ricky Ben","2014-08-17",null,128,"Jack Moyes","2010-07-19",null,null,null,null,null,null,294,"Ricky Ben","2014-08-17"]
[null,239,"Natalia Marlo","2015-12-30",null,303,"Kevin Moor","2010-11-02",null,null,null,null,null,null,239,"Natalia Marlo","2015-12-30"]
[null,103,"Usman Malik","2015-01-09",null,186,"Gregory Austin","2011-06-24",null,null,null,null,null,null,103,"Usman Malik","2015-01-09"]
[null,154,"Jennifer Hick","2012-01-01",null,429,"Kane Austin","2011-10-06",null,null,null,null,null,null,154,"Jennifer Hick","2012-01-01"]
[null,472,"Steve Smith","2014-02-22",null,154,"Jennifer Hick","2012-01-01",null,null,null,null,null,null,472,"Steve Smith","2014-02-22"]
[null,381,"Richard Simpson","2015-11-03",null,472,"Steve Smith","2014-02-22",null,null,null,null,null,null,381,"Richard Simpson","2015-11-03"]
[null,371,"Matthew Shepherd","2014-11-14",null,294,"Ricky Ben","2014-08-17",null,null,null,null,null,null,371,"Matthew Shepherd","2014-11-14"]
[null,186,"Gregory Austin","2011-06-24",null,371,"Matthew Shepherd","2014-11-14",null,null,null,null,null,null,186,"Gregory Austin","2011-06-24"]
[null,250,"Marcus North","2016-08-09",null,103,"Usman Malik","2015-01-09",null,null,null,null,null,null,250,"Marcus North","2016-08-09"]
[null,304,"Peter Boon","2008-03-30",null,381,"Richard Simpson","2015-11-03",null,null,null,null,null,null,304,"Peter Boon","2008-03-30"]
[null,303,"Kevin Moor","2010-11-02",null,239,"Natalia Marlo","2015-12-30",null,null,null,null,null,null,303,"Kevin Moor","2010-11-02"]
[null,128,"Jack Moyes","2010-07-19",null,250,"Marcus North","2016-08-09",null,null,null,null,null,null,128,"Jack Moyes","2010-07-19"]

{"sheet":"SORTBY Function","index":3,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,6],[1,14,1,16]]}
[]
[null,"Use of SORTBY Function",null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<< "]
[]
[null,"Employee ID","Employee Name","Joining Date",null,"Sorted by Date",null,null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Date"]
[null,213,"Frank Orwell","2009-11-18",null,{"$f":"_xlfn.SORTBY(B5:C20,D5:D20,1)","v":304},"Peter Boon",null,null,null,null,null,null,null,213,"Frank Orwell","2009-11-18"]
[null,157,"Alfred Moyes","2010-04-09",null,285,"Shane Williams",null,null,null,null,null,null,null,157,"Alfred Moyes","2010-04-09"]
[null,285,"Shane Williams","2009-08-30",null,213,"Frank Orwell",null,null,null,null,null,null,null,285,"Shane Williams","2009-08-30"]
[null,429,"Kane Austin","2011-10-06",null,157,"Alfred Moyes",null,null,null,null,null,null,null,429,"Kane Austin","2011-10-06"]
[null,294,"Ricky Ben","2014-08-17",null,128,"Jack Moyes",null,null,null,null,null,null,null,294,"Ricky Ben","2014-08-17"]
[null,239,"Natalia Marlo","2015-12-30",null,303,"Kevin Moor",null,null,null,null,null,null,null,239,"Natalia Marlo","2015-12-30"]
[null,103,"Usman Malik","2015-01-09",null,186,"Gregory Austin",null,null,null,null,null,null,null,103,"Usman Malik","2015-01-09"]
[null,154,"Jennifer Hick","2012-01-01",null,429,"Kane Austin",null,null,null,null,null,null,null,154,"Jennifer Hick","2012-01-01"]
[null,472,"Steve Smith","2014-02-22",null,154,"Jennifer Hick",null,null,null,null,null,null,null,472,"Steve Smith","2014-02-22"]
[null,381,"Richard Simpson","2015-11-03",null,472,"Steve Smith",null,null,null,null,null,null,null,381,"Richard Simpson","2015-11-03"]
[null,371,"Matthew Shepherd","2014-11-14",null,294,"Ricky Ben",null,null,null,null,null,null,null,371,"Matthew Shepherd","2014-11-14"]
[null,186,"Gregory Austin","2011-06-24",null,371,"Matthew Shepherd",null,null,null,null,null,null,null,186,"Gregory Austin","2011-06-24"]
[null,250,"Marcus North","2016-08-09",null,103,"Usman Malik",null,null,null,null,null,null,null,250,"Marcus North","2016-08-09"]
[null,304,"Peter Boon","2008-03-30",null,381,"Richard Simpson",null,null,null,null,null,null,null,304,"Peter Boon","2008-03-30"]
[null,303,"Kevin Moor","2010-11-02",null,239,"Natalia Marlo",null,null,null,null,null,null,null,303,"Kevin Moor","2010-11-02"]
[null,128,"Jack Moyes","2010-07-19",null,250,"Marcus North",null,null,null,null,null,null,null,128,"Jack Moyes","2010-07-19"]

{"sheet":"SORTBY For Months","index":4,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7],[1,15,1,17]]}
[]
[null,"Using SORTBY and MONTH Functions",null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<< "]
[]
[null,"Employee ID","Employee Name","Joining Date",null,"Sorted by Month",null,null,null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Date"]
[null,213,"Frank Orwell","2009-11-18",null,{"$f":"_xlfn.SORTBY(B5:D20,MONTH(D5:D20),1)","v":103},"Usman Malik","2015-01-09",null,null,null,null,null,null,null,213,"Frank Orwell","2009-11-18"]
[null,157,"Alfred Moyes","2010-04-09",null,154,"Jennifer Hick","2012-01-01",null,null,null,null,null,null,null,157,"Alfred Moyes","2010-04-09"]
[null,285,"Shane Williams","2009-08-30",null,472,"Steve Smith","2014-02-22",null,null,null,null,null,null,null,285,"Shane Williams","2009-08-30"]
[null,429,"Kane Austin","2011-10-06",null,304,"Peter Boon","2008-03-30",null,null,null,null,null,null,null,429,"Kane Austin","2011-10-06"]
[null,294,"Ricky Ben","2014-08-17",null,157,"Alfred Moyes","2010-04-09",null,null,null,null,null,null,null,294,"Ricky Ben","2014-08-17"]
[null,239,"Natalia Marlo","2015-12-30",null,186,"Gregory Austin","2011-06-24",null,null,null,null,null,null,null,239,"Natalia Marlo","2015-12-30"]
[null,103,"Usman Malik","2015-01-09",null,128,"Jack Moyes","2010-07-19",null,null,null,null,null,null,null,103,"Usman Malik","2015-01-09"]
[null,154,"Jennifer Hick","2012-01-01",null,285,"Shane Williams","2009-08-30",null,null,null,null,null,null,null,154,"Jennifer Hick","2012-01-01"]
[null,472,"Steve Smith","2014-02-22",null,294,"Ricky Ben","2014-08-17",null,null,null,null,null,null,null,472,"Steve Smith","2014-02-22"]
[null,381,"Richard Simpson","2015-11-03",null,250,"Marcus North","2016-08-09",null,null,null,null,null,null,null,381,"Richard Simpson","2015-11-03"]
[null,371,"Matthew Shepherd","2014-11-14",null,429,"Kane Austin","2011-10-06",null,null,null,null,null,null,null,371,"Matthew Shepherd","2014-11-14"]
[null,186,"Gregory Austin","2011-06-24",null,213,"Frank Orwell","2009-11-18",null,null,null,null,null,null,null,186,"Gregory Austin","2011-06-24"]
[null,250,"Marcus North","2016-08-09",null,381,"Richard Simpson","2015-11-03",null,null,null,null,null,null,null,250,"Marcus North","2016-08-09"]
[null,304,"Peter Boon","2008-03-30",null,371,"Matthew Shepherd","2014-11-14",null,null,null,null,null,null,null,304,"Peter Boon","2008-03-30"]
[null,303,"Kevin Moor","2010-11-02",null,303,"Kevin Moor","2010-11-02",null,null,null,null,null,null,null,303,"Kevin Moor","2010-11-02"]
[null,128,"Jack Moyes","2010-07-19",null,239,"Natalia Marlo","2015-12-30",null,null,null,null,null,null,null,128,"Jack Moyes","2010-07-19"]

{"sheet":"SORTBY For Days","index":5,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7],[1,13,1,15]]}
[]
[null,"Applying SORTBY and DAY Functions",null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<< "]
[]
[null,"Employee ID","Employee Name","Joining Date",null,"Sorted by Days",null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Date"]
[null,213,"Frank Orwell","2009-11-18",null,{"$f":"_xlfn.SORTBY(B5:D20,DAY(D5:D20),1)","v":154},"Jennifer Hick","2012-01-01",null,null,null,null,null,213,"Frank Orwell","2009-11-18"]
[null,157,"Alfred Moyes","2010-04-09",null,303,"Kevin Moor","2010-11-02",null,null,null,null,null,157,"Alfred Moyes","2010-04-09"]
[null,285,"Shane Williams","2009-08-30",null,381,"Richard Simpson","2015-11-03",null,null,null,null,null,285,"Shane Williams","2009-08-30"]
[null,429,"Kane Austin","2011-10-06",null,429,"Kane Austin","2011-10-06",null,null,null,null,null,429,"Kane Austin","2011-10-06"]
[null,294,"Ricky Ben","2014-08-17",null,157,"Alfred Moyes","2010-04-09",null,null,null,null,null,294,"Ricky Ben","2014-08-17"]
[null,239,"Natalia Marlo","2015-12-30",null,103,"Usman Malik","2015-01-09",null,null,null,null,null,239,"Natalia Marlo","2015-12-30"]
[null,103,"Usman Malik","2015-01-09",null,250,"Marcus North","2016-08-09",null,null,null,null,null,103,"Usman Malik","2015-01-09"]
[null,154,"Jennifer Hick","2012-01-01",null,371,"Matthew Shepherd","2014-11-14",null,null,null,null,null,154,"Jennifer Hick","2012-01-01"]
[null,472,"Steve Smith","2014-02-22",null,294,"Ricky Ben","2014-08-17",null,null,null,null,null,472,"Steve Smith","2014-02-22"]
[null,381,"Richard Simpson","2015-11-03",null,213,"Frank Orwell","2009-11-18",null,null,null,null,null,381,"Richard Simpson","2015-11-03"]
[null,371,"Matthew Shepherd","2014-11-14",null,128,"Jack Moyes","2010-07-19",null,null,null,null,null,371,"Matthew Shepherd","2014-11-14"]
[null,186,"Gregory Austin","2011-06-24",null,472,"Steve Smith","2014-02-22",null,null,null,null,null,186,"Gregory Austin","2011-06-24"]
[null,250,"Marcus North","2016-08-09",null,186,"Gregory Austin","2011-06-24",null,null,null,null,null,250,"Marcus North","2016-08-09"]
[null,304,"Peter Boon","2008-03-30",null,285,"Shane Williams","2009-08-30",null,null,null,null,null,304,"Peter Boon","2008-03-30"]
[null,303,"Kevin Moor","2010-11-02",null,239,"Natalia Marlo","2015-12-30",null,null,null,null,null,303,"Kevin Moor","2010-11-02"]
[null,128,"Jack Moyes","2010-07-19",null,304,"Peter Boon","2008-03-30",null,null,null,null,null,128,"Jack Moyes","2010-07-19"]

{"sheet":"SORTBY For Years","index":6,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7],[1,13,1,15]]}
[]
[null,"Using SORTBY and YEAR Functions",null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<< "]
[]
[null,"Employee ID","Employee Name","Joining Date",null,"Sorted by Year",null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Date"]
[null,213,"Frank Orwell","2009-11-18",null,{"$f":"_xlfn.SORTBY(B5:D20,YEAR(D5:D20),1)","v":304},"Peter Boon","2008-03-30",null,null,null,null,null,213,"Frank Orwell","2009-11-18"]
[null,157,"Alfred Moyes","2010-04-09",null,213,"Frank Orwell","2009-11-18",null,null,null,null,null,157,"Alfred Moyes","2010-04-09"]
[null,285,"Shane Williams","2009-08-30",null,285,"Shane Williams","2009-08-30",null,null,null,null,null,285,"Shane Williams","2009-08-30"]
[null,429,"Kane Austin","2011-10-06",null,157,"Alfred Moyes","2010-04-09",null,null,null,null,null,429,"Kane Austin","2011-10-06"]
[null,294,"Ricky Ben","2014-08-17",null,303,"Kevin Moor","2010-11-02",null,null,null,null,null,294,"Ricky Ben","2014-08-17"]
[null,239,"Natalia Marlo","2015-12-30",null,128,"Jack Moyes","2010-07-19",null,null,null,null,null,239,"Natalia Marlo","2015-12-30"]
[null,103,"Usman Malik","2015-01-09",null,429,"Kane Austin","2011-10-06",null,null,null,null,null,103,"Usman Malik","2015-01-09"]
[null,154,"Jennifer Hick","2012-01-01",null,186,"Gregory Austin","2011-06-24",null,null,null,null,null,154,"Jennifer Hick","2012-01-01"]
[null,472,"Steve Smith","2014-02-22",null,154,"Jennifer Hick","2012-01-01",null,null,null,null,null,472,"Steve Smith","2014-02-22"]
[null,381,"Richard Simpson","2015-11-03",null,294,"Ricky Ben","2014-08-17",null,null,null,null,null,381,"Richard Simpson","2015-11-03"]
[null,371,"Matthew Shepherd","2014-11-14",null,472,"Steve Smith","2014-02-22",null,null,null,null,null,371,"Matthew Shepherd","2014-11-14"]
[null,186,"Gregory Austin","2011-06-24",null,371,"Matthew Shepherd","2014-11-14",null,null,null,null,null,186,"Gregory Austin","2011-06-24"]
[null,250,"Marcus North","2016-08-09",null,239,"Natalia Marlo","2015-12-30",null,null,null,null,null,250,"Marcus North","2016-08-09"]
[null,304,"Peter Boon","2008-03-30",null,103,"Usman Malik","2015-01-09",null,null,null,null,null,304,"Peter Boon","2008-03-30"]
[null,303,"Kevin Moor","2010-11-02",null,381,"Richard Simpson","2015-11-03",null,null,null,null,null,303,"Kevin Moor","2010-11-02"]
[null,128,"Jack Moyes","2010-07-19",null,250,"Marcus North","2016-08-09",null,null,null,null,null,128,"Jack Moyes","2010-07-19"]

{"sheet":"SORTBY For Months and Days","index":7,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,5,3,7],[1,11,1,13]]}
[]
[null,"Using SORTBY, DAY, and MONTH Functions",null,null,null,null,null,null,null,null,null,">>> Do Yourself <<< "]
[]
[null,"Student ID","Student  Name","Birthday",null,"Sorted by Birthday",null,null,null,null,null,"Student ID","Student  Name","Birthday"]
[null,213,"Frank Orwell","2009-01-02",null,{"$f":"_xlfn.SORTBY(B5:D20,MONTH(D5:D20)+(DAY(D5:D20)/100))","v":213},"Frank Orwell","2009-01-02",null,null,null,213,"Frank Orwell","2009-01-02"]
[null,157,"Alfred Moyes","2010-12-09",null,250,"Marcus North","2009-01-16",null,null,null,157,"Alfred Moyes","2010-12-09"]
[null,285,"Shane Williams","2009-08-12",null,294,"Ricky Ben","2009-01-18",null,null,null,285,"Shane Williams","2009-08-12"]
[null,429,"Kane Austin","2008-05-17",null,303,"Kevin Moor","2008-01-30",null,null,null,429,"Kane Austin","2008-05-17"]
[null,294,"Ricky Ben","2009-01-18",null,239,"Natalia Marlo","2008-02-25",null,null,null,294,"Ricky Ben","2009-01-18"]
[null,239,"Natalia Marlo","2008-02-25",null,472,"Steve Smith","2009-03-29",null,null,null,239,"Natalia Marlo","2008-02-25"]
[null,103,"Usman Malik","2008-10-17",null,304,"Peter Boon","2008-04-30",null,null,null,103,"Usman Malik","2008-10-17"]
[null,154,"Jennifer Hick","2009-11-21",null,429,"Kane Austin","2008-05-17",null,null,null,154,"Jennifer Hick","2009-11-21"]
[null,472,"Steve Smith","2009-03-29",null,128,"Jack Moyes","2008-07-16",null,null,null,472,"Steve Smith","2009-03-29"]
[null,381,"Richard Simpson","2010-09-06",null,285,"Shane Williams","2009-08-12",null,null,null,381,"Richard Simpson","2010-09-06"]
[null,371,"Matthew Shepherd","2008-08-12",null,371,"Matthew Shepherd","2008-08-12",null,null,null,371,"Matthew Shepherd","2008-08-12"]
[null,186,"Gregory Austin","2010-10-26",null,381,"Richard Simpson","2010-09-06",null,null,null,186,"Gregory Austin","2010-10-26"]
[null,250,"Marcus North","2009-01-16",null,103,"Usman Malik","2008-10-17",null,null,null,250,"Marcus North","2009-01-16"]
[null,304,"Peter Boon","2008-04-30",null,186,"Gregory Austin","2010-10-26",null,null,null,304,"Peter Boon","2008-04-30"]
[null,303,"Kevin Moor","2008-01-30",null,154,"Jennifer Hick","2009-11-21",null,null,null,303,"Kevin Moor","2008-01-30"]
[null,128,"Jack Moyes","2008-07-16",null,157,"Alfred Moyes","2010-12-09",null,null,null,128,"Jack Moyes","2008-07-16"]

{"sheet":"INDEX-MATCH-RANK","index":8,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,6,3,8],[1,13,1,16]]}
[]
[null,"Applying INDEX, MATCH, ROW, and RANK Functions",null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Employee ID","Employee Name","Salary","Joining Date",null,"Sorted by Date",null,null,null,null,null,null,"Employee ID","Employee Name","Salary","Joining Date"]
[null,213,"Frank Orwell",36000,"2009-11-18",null,{"$f":"INDEX(B5:E20,MATCH(ROW(A1:A16),RANK(E5:E20,E5:E20,1),0),{1,2,4})","v":304},"Peter Boon","2008-03-30",null,null,null,null,213,"Frank Orwell",36000,"2009-11-18"]
[null,157,"Alfred Moyes",15000,"2010-04-09",null,285,"Shane Williams","2009-08-30",null,null,null,null,157,"Alfred Moyes",15000,"2010-04-09"]
[null,285,"Shane Williams",30000,"2009-08-30",null,213,"Frank Orwell","2009-11-18",null,null,null,null,285,"Shane Williams",30000,"2009-08-30"]
[null,429,"Kane Austin",18000,"2011-10-06",null,157,"Alfred Moyes","2010-04-09",null,null,null,null,429,"Kane Austin",18000,"2011-10-06"]
[null,294,"Ricky Ben",36000,"2014-08-17",null,128,"Jack Moyes","2010-07-19",null,null,null,null,294,"Ricky Ben",36000,"2014-08-17"]
[null,239,"Natalia Marlo",38000,"2015-12-30",null,303,"Kevin Moor","2010-11-02",null,null,null,null,239,"Natalia Marlo",38000,"2015-12-30"]
[null,103,"Usman Malik",32000,"2015-01-09",null,186,"Gregory Austin","2011-06-24",null,null,null,null,103,"Usman Malik",32000,"2015-01-09"]
[null,154,"Jennifer Hick",28000,"2012-01-01",null,429,"Kane Austin","2011-10-06",null,null,null,null,154,"Jennifer Hick",28000,"2012-01-01"]
[null,472,"Steve Smith",35000,"2014-02-22",null,154,"Jennifer Hick","2012-01-01",null,null,null,null,472,"Steve Smith",35000,"2014-02-22"]
[null,381,"Richard Simpson",44000,"2015-11-03",null,472,"Steve Smith","2014-02-22",null,null,null,null,381,"Richard Simpson",44000,"2015-11-03"]
[null,371,"Matthew Shepherd",42000,"2014-11-14",null,294,"Ricky Ben","2014-08-17",null,null,null,null,371,"Matthew Shepherd",42000,"2014-11-14"]
[null,186,"Gregory Austin",24000,"2011-06-24",null,371,"Matthew Shepherd","2014-11-14",null,null,null,null,186,"Gregory Austin",24000,"2011-06-24"]
[null,250,"Marcus North",16000,"2016-08-09",null,103,"Usman Malik","2015-01-09",null,null,null,null,250,"Marcus North",16000,"2016-08-09"]
[null,304,"Peter Boon",23000,"2008-03-30",null,381,"Richard Simpson","2015-11-03",null,null,null,null,304,"Peter Boon",23000,"2008-03-30"]
[null,303,"Kevin Moor",40000,"2010-11-02",null,239,"Natalia Marlo","2015-12-30",null,null,null,null,303,"Kevin Moor",40000,"2010-11-02"]
[null,128,"Jack Moyes",23000,"2010-07-19",null,250,"Marcus North","2016-08-09",null,null,null,null,128,"Jack Moyes",23000,"2010-07-19"]

{"sheet":"VBA","index":9,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,13,1,15]]}
[]
[null,"Applying VBA",null,null,null,null,null,null,null,null,null,null,null,">>> Do Yourself <<< "]
[]
[null,"Employee ID","Employee Name","Joining Date",null,null,null,null,null,null,null,null,null,"Employee ID","Employee Name","Joining Date"]
[null,304,"Peter Boon","2008-03-30",null,null,null,null,null,null,null,null,null,213,"Frank Orwell","2009-11-18"]
[null,285,"Shane Williams","2009-08-30",null,null,null,null,null,null,null,null,null,157,"Alfred Moyes","2010-04-09"]
[null,213,"Frank Orwell","2009-11-18",null,null,null,null,null,null,null,null,null,285,"Shane Williams","2009-08-30"]
[null,157,"Alfred Moyes","2010-04-09",null,null,null,null,null,null,null,null,null,429,"Kane Austin","2011-10-06"]
[null,128,"Jack Moyes","2010-07-19",null,null,null,null,null,null,null,null,null,294,"Ricky Ben","2014-08-17"]
[null,303,"Kevin Moor","2010-11-02",null,null,null,null,null,null,null,null,null,239,"Natalia Marlo","2015-12-30"]
[null,186,"Gregory Austin","2011-06-24",null,null,null,null,null,null,null,null,null,103,"Usman Malik","2015-01-09"]
[null,429,"Kane Austin","2011-10-06",null,null,null,null,null,null,null,null,null,154,"Jennifer Hick","2012-01-01"]
[null,154,"Jennifer Hick","2012-01-01",null,null,null,null,null,null,null,null,null,472,"Steve Smith","2014-02-22"]
[null,472,"Steve Smith","2014-02-22",null,null,null,null,null,null,null,null,null,381,"Richard Simpson","2015-11-03"]
[null,294,"Ricky Ben","2014-08-17",null,null,null,null,null,null,null,null,null,371,"Matthew Shepherd","2014-11-14"]
[null,371,"Matthew Shepherd","2014-11-14",null,null,null,null,null,null,null,null,null,186,"Gregory Austin","2011-06-24"]
[null,103,"Usman Malik","2015-01-09",null,null,null,null,null,null,null,null,null,250,"Marcus North","2016-08-09"]
[null,381,"Richard Simpson","2015-11-03",null,null,null,null,null,null,null,null,null,304,"Peter Boon","2008-03-30"]
[null,239,"Natalia Marlo","2015-12-30",null,null,null,null,null,null,null,null,null,303,"Kevin Moor","2010-11-02"]
[null,250,"Marcus North","2016-08-09",null,null,null,null,null,null,null,null,null,128,"Jack Moyes","2010-07-19"]