{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Method 1 & 2","Filter","SORT function","Sort by last name","Array formula","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Method 1 & 2","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Sorting Alphabetically in Excel with Multiple Columns",null,null,null,null,"Try Yourself"]
[]
[null,"Movies","Genre","IMDB Score",null,null,"Movies","Genre","IMDB Score"]
[null,"Mad Max:Fury Road","Action",8.1,null,null,"Mad Max:Fury Road","Action",8.1]
[null,"Step Brothers","Comedy",6.9,null,null,"Step Brothers","Comedy",6.9]
[null,"Don't Worry Darling","Drama",6.2,null,null,"Don't Worry Darling","Drama",6.2]
[null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007,null,null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007]
[null,"The Menu","Horror",7.6,null,null,"The Menu","Horror",7.6]
[null,"Where the Crowdads Sing","Mystery",7.1,null,null,"Where the Crowdads Sing","Mystery",7.1]
[null,"Disenchanted","Romance",5.9,null,null,"Disenchanted","Romance",5.9]
[null,"Get Out","Thriller",7.7,null,null,"Get Out","Thriller",7.7]
[null,"Enola Holmes 2 ","Crime",6.8,null,null,"Enola Holmes 2 ","Crime",6.8]
[null,"All Quiet on the Western Front ","War",7.9,null,null,"All Quiet on the Western Front ","War",7.9]

{"sheet":"Filter","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Sorting Alphabetically in Excel with Multiple Columns",null,null,null,null,"Try Yourself"]
[]
[null,"Movies","Genre","IMDB Score",null,null,"Movies","Genre","IMDB Score"]
[null,"Mad Max:Fury Road","Action",8.1,null,null,"Mad Max:Fury Road","Action",8.1]
[null,"Step Brothers","Comedy",6.9,null,null,"Step Brothers","Comedy",6.9]
[null,"Don't Worry Darling","Drama",6.2,null,null,"Don't Worry Darling","Drama",6.2]
[null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007,null,null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007]
[null,"The Menu","Horror",7.6,null,null,"The Menu","Horror",7.6]
[null,"Where the Crowdads Sing","Mystery",7.1,null,null,"Where the Crowdads Sing","Mystery",7.1]
[null,"Disenchanted","Romance",5.9,null,null,"Disenchanted","Romance",5.9]
[null,"Get Out","Thriller",7.7,null,null,"Get Out","Thriller",7.7]
[null,"Enola Holmes 2 ","Crime",6.8,null,null,"Enola Holmes 2 ","Crime",6.8]
[null,"All Quiet on the Western Front ","War",7.9,null,null,"All Quiet on the Western Front ","War",7.9]

{"sheet":"SORT function","index":2,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,5,2,7],[2,10,2,12]]}
[]
[]
[null,"Sorting Alphabetically in Excel with Multiple Columns",null,null,null,"Sorting Alphabetically in Excel with Multiple Columns",null,null,null,null,"Try Yourself"]
[]
[null,"Movies","Genre","IMDB Score",null,"Movies","Genre","IMDB Score",null,null,"Movies","Genre","IMDB Score"]
[null,"Mad Max:Fury Road","Action",8.1,null,{"$f":"_xlfn._xlws.SORT(B6:D15,1,1)","v":"All Quiet on the Western Front "},"War",7.9,null,null,"Mad Max:Fury Road","Action",8.1]
[null,"Step Brothers","Comedy",6.9,null,"Disenchanted","Romance",5.9,null,null,"Step Brothers","Comedy",6.9]
[null,"Don't Worry Darling","Drama",6.2,null,"Don't Worry Darling","Drama",6.2,null,null,"Don't Worry Darling","Drama",6.2]
[null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007,null,"Enola Holmes 2 ","Crime",6.8,null,null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007]
[null,"The Menu","Horror",7.6,null,"Get Out","Thriller",7.7,null,null,"The Menu","Horror",7.6]
[null,"Where the Crowdads Sing","Mystery",7.1,null,"Mad Max:Fury Road","Action",8.1,null,null,"Where the Crowdads Sing","Mystery",7.1]
[null,"Disenchanted","Romance",5.9,null,"Step Brothers","Comedy",6.9,null,null,"Disenchanted","Romance",5.9]
[null,"Get Out","Thriller",7.7,null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007,null,null,"Get Out","Thriller",7.7]
[null,"Enola Holmes 2 ","Crime",6.8,null,"The Menu","Horror",7.6,null,null,"Enola Holmes 2 ","Crime",6.8]
[null,"All Quiet on the Western Front ","War",7.9,null,"Where the Crowdads Sing","Mystery",7.1,null,null,"All Quiet on the Western Front ","War",7.9]

{"sheet":"Sort by last name","index":3,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,1,5,1],[2,1,2,4],[4,2,4,4],[2,8,2,11],[4,8,5,8],[4,9,4,11]]}
[]
[]
[null,"Sorting Alphabetically in Excel with Multiple Columns",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Movies","Director",null,null,null,null,null,"Movies","Director"]
[null,null,"First Name","Last Name","Listing Order",null,null,null,null,"First Name","Last Name","Listing Order"]
[null,"All Quiet on the Western Front ","Edward","Berger","Berger,Edward",null,null,null,"All Quiet on the Western Front ","Edward","Berger"]
[null,"Enola Holmes 2 ","Harry","Bradbeer","Bradbeer,Harry",null,null,null,"Enola Holmes 2 ","Harry","Bradbeer"]
[null,"The Lord of the Rings: The Fellowship of the Ring","Peter","Jackson","Jackson,Peter",null,null,null,"The Lord of the Rings: The Fellowship of the Ring","Peter","Jackson"]
[null,"Step Brothers","Adam","Mckay","Mckay,Adam",null,null,null,"Step Brothers","Adam","Mckay"]
[null,"Mad Max:Fury Road","George","Miller","Miller,George",null,null,null,"Mad Max:Fury Road","George","Miller"]
[null,"The Menu","Mark","Mylod","Mylod,Mark",null,null,null,"The Menu","Mark","Mylod"]
[null,"Where the Crowdads Sing","Olivia","Newman","Newman,Olivia",null,null,null,"Where the Crowdads Sing","Olivia","Newman"]
[null,"Get Out","Jordan","Peele","Peele,Jordan",null,null,null,"Get Out","Jordan","Peele"]
[null,"Disenchanted","Adam","Shankman","Shankman,Adam",null,null,null,"Disenchanted","Adam","Shankman"]
[null,"Don't Worry Darling","Olivia","Wilde","Wilde,Olivia",null,null,null,"Don't Worry Darling","Olivia","Wilde"]

{"sheet":"Array formula","index":4,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,5,2,7],[2,10,2,12]]}
[]
[]
[null,"Sorting Alphabetically in Excel with Multiple Columns",null,null,null,"Sorting Alphabetically in Excel with Multiple Columns",null,null,null,null,"Try Yourself"]
[]
[null,"Movies","Genre","IMDB Score",null,"Movies","Genre","IMDB Score",null,null,"Movies","Genre","IMDB Score"]
[null,"Mad Max:Fury Road","Action",8.1,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B6),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"All Quiet on the Western Front "},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C6),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"Action"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D6),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":5.9},null,null,"Mad Max:Fury Road","Action",8.1]
[null,"Step Brothers","Comedy",6.9,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B7),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"Disenchanted"},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C7),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"Comedy"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D7),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":6.2},null,null,"Step Brothers","Comedy",6.9]
[null,"Don't Worry Darling","Drama",6.2,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B8),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"Don't Worry Darling"},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C8),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"Crime"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D8),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":6.8},null,null,"Don't Worry Darling","Drama",6.2]
[null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B9),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"Enola Holmes 2 "},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C9),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"Drama"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D9),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":6.9},null,null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007]
[null,"The Menu","Horror",7.6,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B10),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"Get Out"},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C10),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"Fantasy"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D10),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":7.1},null,null,"The Menu","Horror",7.6]
[null,"Where the Crowdads Sing","Mystery",7.1,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B11),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"Mad Max:Fury Road"},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C11),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"Horror"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D11),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":7.6},null,null,"Where the Crowdads Sing","Mystery",7.1]
[null,"Disenchanted","Romance",5.9,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B12),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"Step Brothers"},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C12),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"Mystery"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D12),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":7.7},null,null,"Disenchanted","Romance",5.9]
[null,"Get Out","Thriller",7.7,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B13),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"The Lord of the Rings: The Fellowship of the Ring"},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C13),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"Romance"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D13),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":7.9},null,null,"Get Out","Thriller",7.7]
[null,"Enola Holmes 2 ","Crime",6.8,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B14),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"The Menu"},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C14),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"Thriller"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D14),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":8.1},null,null,"Enola Holmes 2 ","Crime",6.8]
[null,"All Quiet on the Western Front ","War",7.9,null,{"$f":"INDEX(B$6:B$15,MATCH(ROWS(B$6:B15),\nCOUNTIF(B$6:B$15,\"<=\"&B$6:B$15),0))","v":"Where the Crowdads Sing"},{"$f":"INDEX(C$6:C$15,MATCH(ROWS(C$6:C15),\nCOUNTIF(C$6:C$15,\"<=\"&C$6:C$15),0))","v":"War"},{"$f":"INDEX(D$6:D$15,MATCH(ROWS(D$6:D15),\nCOUNTIF(D$6:D$15,\"<=\"&D$6:D$15),0))","v":8.8000000000000007},null,null,"All Quiet on the Western Front ","War",7.9]

{"sheet":"VBA","index":5,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,7,2,9]]}
[]
[]
[null,"Sorting Alphabetically in Excel with Multiple Columns",null,null,null,null,null,"Try Youself"]
[]
[null,"Movies","Genre","IMDB Score",null,null,null,"Movies","Genre","IMDB Score"]
[null,"All Quiet on the Western Front ","War",7.9,null,null,null,"Mad Max:Fury Road","Action",8.1]
[null,"Disenchanted","Romance",5.9,null,null,null,"Step Brothers","Comedy",6.9]
[null,"Don't Worry Darling","Drama",6.2,null,null,null,"Don't Worry Darling","Drama",6.2]
[null,"Enola Holmes 2 ","Crime",6.8,null,null,null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007]
[null,"Get Out","Thriller",7.7,null,null,null,"The Menu","Horror",7.6]
[null,"Mad Max:Fury Road","Action",8.1,null,null,null,"Where the Crowdads Sing","Mystery",7.1]
[null,"Step Brothers","Comedy",6.9,null,null,null,"Disenchanted","Romance",5.9]
[null,"The Lord of the Rings: The Fellowship of the Ring","Fantasy",8.8000000000000007,null,null,null,"Get Out","Thriller",7.7]
[null,"The Menu","Horror",7.6,null,null,null,"Enola Holmes 2 ","Crime",6.8]
[null,"Where the Crowdads Sing","Mystery",7.1,null,null,null,"All Quiet on the Western Front ","War",7.9]