{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Sort by Date","Chronological Order","Entire Sheet","Sort by Month","Sort by Year","Sort by Weekday","Month and Day","Month Name","Sort Macro","Excel Formula"],"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":"Sort by Date","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sort Excel Sheet by Date"]
[]
[null,"Name","Joining Date","Birth Day","Weekday"]
[null,"Walter ","2010-10-22","1992-08-18","1990-10-15"]
[null,"Jesse ","2001-07-04","1987-05-12","1992-11-01"]
[null,"Hank","2011-11-10","1991-10-19","1982-03-26"]
[null,"Mike ","2005-08-26","1989-03-25","1993-05-24"]
[null,"Gus ","2018-03-18","1994-06-11","1985-07-25"]
[null,"Sheldon","2010-09-28","1993-06-15","1987-05-23"]
[null,"Stuart","2021-12-16","1991-08-19","1984-01-25"]
[null,"Rachel ","2006-01-20","1989-05-03","1981-12-04"]
[null,"Joey","2019-06-19","1999-09-09","1990-06-12"]
[null,"Phoebe","2022-02-13","1982-04-01","1991-01-24"]

{"sheet":"Chronological Order","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sort Excel Sheet in Chronological Order"]
[]
[null,"Name","Joining Date","Birth Day","Weekday"]
[null,"Walter ","2010-10-22","1992-08-18","1990-10-15"]
[null,"Jesse ","2001-07-04","1987-05-12","1992-11-01"]
[null,"Hank","2011-11-10","1991-10-19","1982-03-26"]
[null,"Mike ","2005-08-26","1989-03-25","1993-05-24"]
[null,"Gus ","2018-03-18","1994-06-11","1985-07-25"]
[null,"Sheldon","2010-09-28","1993-06-15","1987-05-23"]
[null,"Stuart","2021-12-16","1991-08-19","1984-01-25"]
[null,"Rachel ","2006-01-20","1989-05-03","1981-12-04"]
[null,"Joey","2019-06-19","1999-09-09","1990-06-12"]
[null,"Phoebe","2022-02-13","1982-04-01","1991-01-24"]

{"sheet":"Entire Sheet","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sort Entire Excel Sheet by Date"]
[]
[null,"Name","Joining Date","Birth Day","Weekday"]
[null,"Joey","2019-06-19","1999-09-09","1990-06-12"]
[null,"Gus ","2018-03-18","1994-06-11","1985-07-25"]
[null,"Sheldon","2010-09-28","1993-06-15","1987-05-23"]
[null,"Walter ","2010-10-22","1992-08-18","1990-10-15"]
[null,"Hank","2011-11-10","1991-10-19","1982-03-26"]
[null,"Stuart","2021-12-16","1991-08-19","1984-01-25"]
[null,"Rachel ","2006-01-20","1989-05-03","1981-12-04"]
[null,"Mike ","2005-08-26","1989-03-25","1993-05-24"]
[null,"Jesse ","2001-07-04","1987-05-12","1992-11-01"]
[null,"Phoebe","2022-02-13","1982-04-01","1991-01-24"]

{"sheet":"Sort by Month","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sort Excel Sheet by Month"]
[]
[null,"Name","Joining Date","Birth Day","Birth Month"]
[null,"Mike ","2005-08-26","1989-03-25",{"$f":"MONTH(D5)","v":3}]
[null,"Phoebe","2022-02-13","1982-04-01",{"$f":"MONTH(D6)","v":4}]
[null,"Jesse ","2001-07-04","1987-05-12",{"$f":"MONTH(D7)","v":5}]
[null,"Rachel ","2006-01-20","1989-05-03",{"$f":"MONTH(D8)","v":5}]
[null,"Gus ","2018-03-18","1994-06-11",{"$f":"MONTH(D9)","v":6}]
[null,"Sheldon","2010-09-28","1993-06-15",{"$f":"MONTH(D10)","v":6}]
[null,"Walter ","2010-10-22","1992-08-18",{"$f":"MONTH(D11)","v":8}]
[null,"Stuart","2021-12-16","1991-08-19",{"$f":"MONTH(D12)","v":8}]
[null,"Joey","2019-06-19","1999-09-09",{"$f":"MONTH(D13)","v":9}]
[null,"Hank","2011-11-10","1991-10-19",{"$f":"MONTH(D14)","v":10}]

{"sheet":"Sort by Year","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sort Excel Sheet by Year"]
[]
[null,"Name","Joining Date","Birth Day","Joining Year"]
[null,"Jesse ","2001-07-04","1987-05-12",{"$f":"YEAR(C5)","v":2001}]
[null,"Mike ","2005-08-26","1989-03-25",{"$f":"YEAR(C6)","v":2005}]
[null,"Rachel ","2006-01-20","1989-05-03",{"$f":"YEAR(C7)","v":2006}]
[null,"Walter ","2010-10-22","1992-08-18",{"$f":"YEAR(C8)","v":2010}]
[null,"Sheldon","2010-09-28","1993-06-15",{"$f":"YEAR(C9)","v":2010}]
[null,"Hank","2011-11-10","1991-10-19",{"$f":"YEAR(C10)","v":2011}]
[null,"Gus ","2018-03-18","1994-06-11",{"$f":"YEAR(C11)","v":2018}]
[null,"Joey","2019-06-19","1999-09-09",{"$f":"YEAR(C12)","v":2019}]
[null,"Stuart","2021-12-16","1991-08-19",{"$f":"YEAR(C13)","v":2021}]
[null,"Phoebe","2022-02-13","1982-04-01",{"$f":"YEAR(C14)","v":2022}]

{"sheet":"Sort by Weekday","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sort Excel Sheet by Weekday"]
[]
[null,"Name","Joining Date","Weekday","Sorted Weekday"]
[null,"Rachel ","2006-01-20","2022-12-04",{"$f":"WEEKDAY(D5)","v":1}]
[null,"Joey","2019-06-19","2022-06-13"]
[null,"Gus ","2018-03-18","2022-07-26"]
[null,"Sheldon","2010-09-28","2022-05-24"]
[null,"Phoebe","2022-02-13","2022-01-26"]
[null,"Jesse ","2001-07-04","2022-11-02"]
[null,"Mike ","2005-08-26","2022-05-26"]
[null,"Stuart","2021-12-16","2022-01-28"]
[null,"Walter ","2010-10-22","2022-10-15"]
[null,"Hank","2011-11-10","2022-03-26"]

{"sheet":"Month and Day","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sort Excel Sheet by Day and Month"]
[]
[null,"Name","Joining Date","Birth Day","Month-Day"]
[null,"Mike ","2005-08-26","1989-03-25",{"$f":"TEXT(D5, \"mm.dd\")","v":"03.25"}]
[null,"Phoebe","2022-02-13","1982-04-01",{"$f":"TEXT(D6, \"mm.dd\")","v":"04.01"}]
[null,"Rachel ","2006-01-20","1989-05-03",{"$f":"TEXT(D7, \"mm.dd\")","v":"05.03"}]
[null,"Jesse ","2001-07-04","1987-05-12",{"$f":"TEXT(D8, \"mm.dd\")","v":"05.12"}]
[null,"Gus ","2018-03-18","1994-06-11",{"$f":"TEXT(D9, \"mm.dd\")","v":"06.11"}]
[null,"Sheldon","2010-09-28","1993-06-15",{"$f":"TEXT(D10, \"mm.dd\")","v":"06.15"}]
[null,"Walter ","2010-10-22","1992-08-18",{"$f":"TEXT(D11, \"mm.dd\")","v":"08.18"}]
[null,"Stuart","2021-12-16","1991-08-19",{"$f":"TEXT(D12, \"mm.dd\")","v":"08.19"}]
[null,"Joey","2019-06-19","1999-09-09",{"$f":"TEXT(D13, \"mm.dd\")","v":"09.09"}]
[null,"Hank","2011-11-10","1991-10-19",{"$f":"TEXT(D14, \"mm.dd\")","v":"10.19"}]

{"sheet":"Month Name","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sort Excel Sheet by Month Name"]
[]
[null,"Name","Joining Date","Joining Month"]
[null,"Stuart","1984-01-25","January"]
[null,"Hank","1982-03-26","March"]
[null,"Gus ","1985-04-25","April"]
[null,"Mike ","1993-05-24","May"]
[null,"Joey","1990-06-12","June"]
[null,"Phoebe","1991-07-24","July"]
[null,"Sheldon","1987-08-23","August"]
[null,"Walter ","1990-10-15","October"]
[null,"Jesse ","1992-11-01","November"]
[null,"Rachel ","1981-12-04","December"]

{"sheet":"Sort Macro","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sort Excel Sheet Using Macro"]
[]
[null,"Name","Joining Date","Birth Day","Weekday"]
[null,"Jesse ","2001-07-04","1987-05-12","1992-11-01"]
[null,"Mike ","2005-08-26","1989-03-25","1993-05-24"]
[null,"Rachel ","2006-01-20","1989-05-03","1981-12-04"]
[null,"Stuart","2021-12-16","1991-08-19","1984-01-25"]
[null,"Hank","2011-11-10","1991-10-19","1982-03-26"]
[null,"Sheldon","2010-09-28","1993-06-15","1987-05-23"]
[null,"Gus ","2018-03-18","1994-06-11","1985-07-25"]
[null,"Joey","2019-06-19","1999-09-09","1990-06-12"]
[null,"Walter ","2010-10-22","2000-08-18","1990-10-15"]
[null,"Phoebe","2022-02-13","2001-04-01","1991-01-24"]

{"sheet":"Excel Formula","index":9,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sort Excel Sheet Using Formula"]
[]
[null,"Name","Joining Date","Birth Day","Sorted Joining Date"]
[null,"Walter ","2010-10-22","1992-08-18",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C5), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2001-07-04"}]
[null,"Jesse ","2001-07-04","1987-05-12",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C6), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2005-08-26"}]
[null,"Hank","2011-11-10","1991-10-19",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C7), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2006-01-20"}]
[null,"Mike ","2005-08-26","1989-03-25",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C8), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2010-09-28"}]
[null,"Gus ","2018-03-18","1994-06-11",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C9), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2010-10-22"}]
[null,"Sheldon","2010-09-28","1993-06-15",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C10), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2011-11-10"}]
[null,"Stuart","2021-12-16","1991-08-19",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C11), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2018-03-18"}]
[null,"Rachel ","2006-01-20","1989-05-03",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C12), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2019-06-19"}]
[null,"Joey","2019-06-19","1999-09-09",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C13), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2021-12-16"}]
[null,"Phoebe","2022-02-13","1982-04-01",{"$f":"IFERROR(INDEX($C$5:$C$14, MATCH(ROWS($C$5:C14), COUNTIF($C$5:$C$14, \"<=\"&$C$5:$C$14), 0)), \"\")","v":"2022-02-13"}]