{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset-1","Ascending Order","Descending Order","Double Click","Match and Sort","Find and Sort","Dataset-2","Multiple Columns","Without Column Header","Color Sort"],"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":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Revenue Earned by Top 15 Companies"]
[]
[null,"Company","Revenue (Billions)"]
[null,"Berkshire Hathaway",276.08999999999997]
[null,"ICBC",208.13]
[null,"Saudi Aramco",400.38]
[null,"JPMorgan Chase",124.54]
[null,"China Construction Bank",202.07]
[null,"Amazon",469.82]
[null,"Apple",378.7]
[null,"Agricultural Bank of China",181.42]
[null,"Bank of America",96.83]
[null,"Toyota Motor",281.75]
[null,"Alphabet",257.49]
[null,"Microsoft",184.9]
[null,"Bank of China",152.43]
[null,"Samsung Group",244.16]
[null,"ExxonMobil",280.51]

{"sheet":"Ascending Order","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,5],[1,1,1,5]]}
[]
[null,"Sorting a Single Column by Header Name in Ascending Order"]
[]
[null,"Unsorted Data",null,null,"Sorted Data"]
[null,"Company","Revenue (Billions)",null,"Company","Revenue (Billions)"]
[null,"Berkshire Hathaway",276.08999999999997,null,"Bank of America",96.83]
[null,"ICBC",208.13,null,"JPMorgan Chase",124.54]
[null,"Saudi Aramco",400.38,null,"Bank of China",152.43]
[null,"JPMorgan Chase",124.54,null,"Agricultural Bank of China",181.42]
[null,"China Construction Bank",202.07,null,"Microsoft",184.9]
[null,"Amazon",469.82,null,"China Construction Bank",202.07]
[null,"Apple",378.7,null,"ICBC",208.13]
[null,"Agricultural Bank of China",181.42,null,"Samsung Group",244.16]
[null,"Bank of America",96.83,null,"Alphabet",257.49]
[null,"Toyota Motor",281.75,null,"Berkshire Hathaway",276.08999999999997]
[null,"Alphabet",257.49,null,"ExxonMobil",280.51]
[null,"Microsoft",184.9,null,"Toyota Motor",281.75]
[null,"Bank of China",152.43,null,"Apple",378.7]
[null,"Samsung Group",244.16,null,"Saudi Aramco",400.38]
[null,"ExxonMobil",280.51,null,"Amazon",469.82]

{"sheet":"Descending Order","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Sorting a Single Column by Header Name in Descending Order"]
[]
[null,"Unsorted Data",null,null,"Sorted Data"]
[null,"Company","Revenue (Billions)",null,"Company","Revenue (Billions)"]
[null,"Berkshire Hathaway",276.08999999999997,null,"Amazon",469.82]
[null,"ICBC",208.13,null,"Saudi Aramco",400.38]
[null,"Saudi Aramco",400.38,null,"Apple",378.7]
[null,"JPMorgan Chase",124.54,null,"Toyota Motor",281.75]
[null,"China Construction Bank",202.07,null,"ExxonMobil",280.51]
[null,"Amazon",469.82,null,"Berkshire Hathaway",276.08999999999997]
[null,"Apple",378.7,null,"Alphabet",257.49]
[null,"Agricultural Bank of China",181.42,null,"Samsung Group",244.16]
[null,"Bank of America",96.83,null,"ICBC",208.13]
[null,"Toyota Motor",281.75,null,"China Construction Bank",202.07]
[null,"Alphabet",257.49,null,"Microsoft",184.9]
[null,"Microsoft",184.9,null,"Agricultural Bank of China",181.42]
[null,"Bank of China",152.43,null,"Bank of China",152.43]
[null,"Samsung Group",244.16,null,"JPMorgan Chase",124.54]
[null,"ExxonMobil",280.51,null,"Bank of America",96.83]

{"sheet":"Double Click","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sorting by Double Clicking Column Header Name"]
[]
[null,"Company","Revenue (Billions)","Year Founded"]
[null,"Agricultural Bank of China",181.42,1979]
[null,"Alphabet",257.49,1998]
[null,"Amazon",469.82,1994]
[null,"Apple",378.7,1976]
[null,"Bank of America",96.83,1998]
[null,"Bank of China",152.43,1929]
[null,"Berkshire Hathaway",276.08999999999997,1939]
[null,"China Construction Bank",202.07,2014]
[null,"ExxonMobil",280.51,1999]
[null,"ICBC",208.13,1984]
[null,"JPMorgan Chase",124.54,2000]
[null,"Microsoft",184.9,1975]
[null,"Samsung Group",244.16,1938]
[null,"Saudi Aramco",400.38,1933]
[null,"Toyota Motor",281.75,1937]

{"sheet":"Match and Sort","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Combining VBA Match Function and Sort Method to Sort Column Header by Name"]
[]
[null,"Unsorted Data",null,null,"Sorted Data"]
[null,"Company","Revenue (Billions)",null,"Company","Revenue (Billions)"]
[null,"Berkshire Hathaway",276.08999999999997,null,"Bank of America",96.83]
[null,"ICBC",208.13,null,"JPMorgan Chase",124.54]
[null,"Saudi Aramco",400.38,null,"Bank of China",152.43]
[null,"JPMorgan Chase",124.54,null,"Agricultural Bank of China",181.42]
[null,"China Construction Bank",202.07,null,"Microsoft",184.9]
[null,"Amazon",469.82,null,"China Construction Bank",202.07]
[null,"Apple",378.7,null,"ICBC",208.13]
[null,"Agricultural Bank of China",181.42,null,"Samsung Group",244.16]
[null,"Bank of America",96.83,null,"Alphabet",257.49]
[null,"Toyota Motor",281.75,null,"Berkshire Hathaway",276.08999999999997]
[null,"Alphabet",257.49,null,"ExxonMobil",280.51]
[null,"Microsoft",184.9,null,"Toyota Motor",281.75]
[null,"Bank of China",152.43,null,"Apple",378.7]
[null,"Samsung Group",244.16,null,"Saudi Aramco",400.38]
[null,"ExxonMobil",280.51,null,"Amazon",469.82]

{"sheet":"Find and Sort","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Find and Sort Methods"]
[]
[null,"Company","Revenue (Billions)","Year Founded"]
[null,"Amazon",469.82,1929]
[null,"Samsung Group",244.16,1933]
[null,"ExxonMobil",280.51,1937]
[null,"Bank of China",152.43,1938]
[null,"Apple",378.7,1939]
[null,"Microsoft",184.9,1975]
[null,"JPMorgan Chase",124.54,1976]
[null,"Berkshire Hathaway",276.08999999999997,1979]
[null,"Toyota Motor",281.75,1984]
[null,"Saudi Aramco",400.38,1994]
[null,"China Construction Bank",202.07,1998]
[null,"ICBC",208.13,1998]
[null,"Bank of America",96.83,1999]
[null,"Alphabet",257.49,2000]
[null,"Agricultural Bank of China",181.42,2014]

{"sheet":"Dataset-2","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employee Information"]
[]
[null,"Name","Salary","Joining Date"]
[null,"Elizabeth Aldridge",50000,"2012-11-20"]
[null,"Thomas Anderson",42000,"2011-09-14"]
[null,"Jettie Long",37000,"2015-03-24"]
[null,"Juliana Ross",42000,"2018-12-15"]
[null,"Walter Vanburen",30000,"2018-06-11"]
[null,"Matthew Wallace",35000,"2017-11-05"]
[null,"Nancy Wilson",48000,"2014-06-08"]
[null,"Justine Wofford",58000,"2015-06-13"]
[null,"James Pittman",50000,"2013-09-11"]
[null,"Steve Smith",36000,"2019-07-25"]

{"sheet":"Multiple Columns","index":7,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,5,3,7],[1,1,1,7]]}
[]
[null,"Sorting Multiple Columns by Header Names"]
[]
[null,"Unsorted Data",null,null,null,"Sorted Data"]
[null,"Name","Salary","Joining Date",null,"Name","Salary","Joining Date"]
[null,"Elizabeth Aldridge",50000,"2012-11-20",null,"Justine Wofford",58000,"2015-06-13"]
[null,"Thomas Anderson",42000,"2011-09-14",null,"Elizabeth Aldridge",50000,"2012-11-20"]
[null,"Jettie Long",37000,"2015-03-24",null,"James Pittman",50000,"2013-09-11"]
[null,"Juliana Ross",42000,"2018-12-15",null,"Nancy Wilson",48000,"2014-06-08"]
[null,"Walter Vanburen",30000,"2018-06-11",null,"Thomas Anderson",42000,"2011-09-14"]
[null,"Matthew Wallace",35000,"2017-11-05",null,"Juliana Ross",42000,"2018-12-15"]
[null,"Nancy Wilson",48000,"2014-06-08",null,"Jettie Long",37000,"2015-03-24"]
[null,"Justine Wofford",58000,"2015-06-13",null,"Steve Smith",36000,"2019-07-25"]
[null,"James Pittman",50000,"2013-09-11",null,"Matthew Wallace",35000,"2017-11-05"]
[null,"Steve Smith",36000,"2019-07-25",null,"Walter Vanburen",30000,"2018-06-11"]

{"sheet":"Without Column Header","index":8,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sorting by Column without Header"]
[]
[null,4]
[null,8]
[null,9]
[null,10]
[null,10]
[null,16]
[null,25]
[null,31]
[null,32]
[null,32]
[null,44]
[null,46]
[null,49]
[null,52]
[null,54]
[null,54]
[null,56]
[null,67]
[null,76]
[null,79]
[null,79]

{"sheet":"Color Sort","index":9,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sorting by Color"]
[]
[null,"Company","Revenue (Billions)","Year Founded"]
[null,"JPMorgan Chase",124.54,1998]
[null,"Apple",378.7,1937]
[null,"Toyota Motor",281.75,2014]
[null,"Berkshire Hathaway",276.08999999999997,1975]
[null,"ICBC",208.13,1933]
[null,"Saudi Aramco",400.38,1979]
[null,"China Construction Bank",202.07,2000]
[null,"Amazon",469.82,1976]
[null,"Agricultural Bank of China",181.42,1939]
[null,"Bank of America",96.83,1984]
[null,"Alphabet",257.49,1994]
[null,"Microsoft",184.9,1998]
[null,"Bank of China",152.43,1929]
[null,"Samsung Group",244.16,1938]
[null,"ExxonMobil",280.51,1999]