{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["SORT","UNIQUE_SORT","Sheet1","Sheet2","Table_Power","Data_Power","Sheet8","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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","index":0,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of SORT Function",null,null,null,null,null,null,null,null,"Use of SORT Function"]
[]
[null,"Fruit","Quantity",null,null,null,null,null,null,null,"Fruit","Quantity"]
[null,"Apple",80,null,{"$f":"_xlfn._xlws.SORT(B5:B13)","v":"Apple"},null,null,null,null,null,"Orange",80]
[null,"Watermelon",20,null,"Apple",null,null,null,null,null,"Watermelon",20]
[null,"Banana",90,null,"Banana",null,null,null,null,null,"Banana",90]
[null,"Pineapple",30,null,"Coconut",null,null,null,null,null,"Pineapple",30]
[null,"Apple",40,null,"Mandarin",null,null,null,null,null,"Apple",40]
[null,"Mango",50,null,"Mango",null,null,null,null,null,"Mango",50]
[null,"Coconut",30,null,"Pear",null,null,null,null,null,"Coconut",30]
[null,"Mandarin",80,null,"Pineapple",null,null,null,null,null,"Mandarin",80]
[null,"Pear",70,null,"Watermelon",null,null,null,null,null,"Pear",70]

{"sheet":"UNIQUE_SORT","index":1,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"UNIQUE & SORT Functions",null,null,null,null,null,null,null,null,"UNIQUE & SORT Functions"]
[]
[null,"Fruit","Quantity",null,null,null,null,null,null,null,"Fruit","Quantity"]
[null,"Orange",80,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(B5:B13))","v":"Apple"},null,null,null,null,null,"Orange",80]
[null,"Apple",60,null,"Banana",null,null,null,null,null,"Apple",60]
[null,"Banana",90,null,"Coconut",null,null,null,null,null,"Banana",90]
[null,"Coconut",30,null,"Mango",null,null,null,null,null,"Coconut",30]
[null,"Apple",40,null,"Orange",null,null,null,null,null,"Apple",40]
[null,"Mango",50,null,"Pear",null,null,null,null,null,"Mango",50]
[null,"Coconut",30,null,null,null,null,null,null,null,"Coconut",30]
[null,"Orange",80,null,null,null,null,null,null,null,"Orange",80]
[null,"Pear",70,null,null,null,null,null,null,null,"Pear",70]

{"sheet":"Sheet1","index":2,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Orange"]
["Apple"]
["Banana"]
["Pineapple"]
["Grapes"]
["Mango"]
["Coconut"]
["Lemon"]
["Pear"]
["Cherry"]

{"sheet":"Sheet2","index":3,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A1), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A1)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Apple"}]
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A2), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A2)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Banana"}]
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A3), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A3)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Cherry"}]
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A4), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A4)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Coconut"}]
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A5), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A5)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Grapes"}]
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A6), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A6)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Lemon"}]
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A7), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A7)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Mango"}]
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A8), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A8)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Orange"}]
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A9), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A9)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Pear"}]
[{"$f":"IF(COUNTA(Fruit)>=ROWS($A$1:A10), INDEX(Fruit, MATCH(SMALL(COUNTIF(Fruit, \"<\"&Fruit), ROW(A10)),\nCOUNTIF(Fruit, \"<\"&Fruit), 0)), \"\")","v":"Pineapple"}]
[]
[null,{"$f":"IF(COUNTA(Fruits)>=ROWS($B$5:B20), INDEX(List, MATCH(SMALL(COUNTIF(List, \"<\"&List), ROW(B12)), COUNTIF(List, \"<\"&List), 0)), \"\")","v":""}]
[null,{"$f":"IF(COUNTA(Fruits)>=ROWS($B$5:B21), INDEX(List, MATCH(SMALL(COUNTIF(List, \"<\"&List), ROW(B13)), COUNTIF(List, \"<\"&List), 0)), \"\")","v":""}]
[null,{"$f":"IF(COUNTA(Fruits)>=ROWS($B$5:B22), INDEX(List, MATCH(SMALL(COUNTIF(List, \"<\"&List), ROW(B14)), COUNTIF(List, \"<\"&List), 0)), \"\")","v":""}]
[null,{"$f":"IF(COUNTA(Fruits)>=ROWS($B$5:B23), INDEX(List, MATCH(SMALL(COUNTIF(List, \"<\"&List), ROW(B15)), COUNTIF(List, \"<\"&List), 0)), \"\")","v":""}]
[null,{"$f":"IF(COUNTA(Fruits)>=ROWS($B$5:B24), INDEX(List, MATCH(SMALL(COUNTIF(List, \"<\"&List), ROW(B16)), COUNTIF(List, \"<\"&List), 0)), \"\")","v":""}]

{"sheet":"Table_Power","index":4,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Fruit"]
["Apple"]
["Banana"]
["Coconut"]
["Mandarin"]
["Mango"]
["Orange"]
["Pear"]
["Pineapple"]
["Watermelon"]

{"sheet":"Data_Power","index":5,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,10,1,13],[1,1,1,4]]}
[]
[null,"Use of Power Query",null,null,null,null,null,null,null,null,"Use of Power Query"]
[]
[null,"Fruit","Quantity",null,null,null,null,null,null,null,"Fruit","Quantity"]
[null,"Orange",80,null,null,null,null,null,null,null,"Orange",80]
[null,"Watermelon",20,null,null,null,null,null,null,null,"Watermelon",20]
[null,"Banana",90,null,null,null,null,null,null,null,"Banana",90]
[null,"Pineapple",30,null,null,null,null,null,null,null,"Pineapple",30]
[null,"Apple",40,null,null,null,null,null,null,null,"Apple",40]
[null,"Mango",50,null,null,null,null,null,null,null,"Mango",50]
[null,"Coconut",30,null,null,null,null,null,null,null,"Coconut",30]
[null,"Mandarin",80,null,null,null,null,null,null,null,"Mandarin",80]
[null,"Pear",70,null,null,null,null,null,null,null,"Pear",70]

{"sheet":"Sheet8","index":6,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Source Data For VBA"]
[]
[null,"Fruit"]
[null,"Apple"]
[null,"Banana"]
[null,"Coconut"]
[null,"Dates"]
[null,"Mandarin"]
[null,"Mango"]
[null,"Orange"]
[null,"Pear"]
[null,"Pineapple"]
[null,"Watermelon"]

{"sheet":"VBA","index":7,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of VBA"]
[]
[null,"Apple"]