{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Copy-Paste","advance","result_advance","FILTER","Power query","result_powerquery","Criteria","VBA","pull data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Seller","Product","Quantity","Amount"]
[null,"Alex","Banana",2516,3054]
[null,"Melissa","Orange",2561,4653]
[null,"Sam","Banana",1565,3654]
[null,"Sofia","Mango",1569,3543]
[null,"Afra","Banana",8462,8561]
[null,"Sam","Orange",4315,5062]
[null,"Sofia","Orange",5432,6216]
[null,"Afra","Orange",1542,3697]

{"sheet":"Copy-Paste","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Seller","Product","Quantity","Amount"]
[null,"Alex","Banana",2516,3054]
[null,"Sam","Banana",1565,3654]
[null,"Afra","Banana",8462,8561]

{"sheet":"advance","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Seller","Product","Quantity","Amount"]
[null,"Alex","Banana",2516,3054]
[null,"Melissa","Orange",2561,4653]
[null,"Sam","Banana",1565,3654]
[null,"Sofia","Mango",1569,3543]
[null,"Afra","Banana",8462,8561]
[null,"Sam","Orange",4315,5062]
[null,"Sofia","Orange",5432,6216]
[null,"Afra","Orange",1542,3697]

{"sheet":"result_advance","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,2],[1,1,1,2],[2,1,2,2]]}
[]
[null,"Product"]
[null,"Banana"]
[null,"Banana"]
[]
[null,"Seller","Product","Quantity","Amount"]
[null,"Alex","Banana",2516,3054]
[null,"Sam","Banana",1565,3654]
[null,"Afra","Banana",8462,8561]

{"sheet":"FILTER","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Criteria"]
[null,"Product","Banana"]
[null,"Amount",3500]
[]
[null,"Seller","Product","Quantity","Amount"]
[null,{"$f":"_xlfn._xlws.FILTER(Dataset!B6:E13,(Dataset!C6:C13=FILTER!C3)*(Dataset!E6:E13>FILTER!C4))","v":"Sam"},"Banana",1565,3654]
[null,"Afra","Banana",8462,8561]

{"sheet":"Power query","index":5,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Seller","Product","Quantity","Amount"]
[null,"Alex","Banana",2516,3054]
[null,"Melissa","Orange",2561,4653]
[null,"Sam","Banana",1565,3654]
[null,"Sofia","Mango",1569,3543]
[null,"Afra","Banana",8462,8561]
[null,"Sam","Orange",4315,5062]
[null,"Sofia","Orange",5432,6216]
[null,"Afra","Orange",1542,3697]

{"sheet":"result_powerquery","index":6,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Product","Seller"]
["Banana","Afra"]
["Banana","Alex"]
["Banana","Sam"]

{"sheet":"Criteria","index":7,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4],[4,6,4,7],[6,6,6,7],[5,6,5,7]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Seller","Product","Quantity","Amount",null,"Criteria"]
[null,"Alex","Banana",2516,3054,null,"Product"]
[null,"Melissa","Orange",2561,4653,null,"Banana"]
[null,"Sam","Banana",1565,3654]
[null,"Sofia","Mango",1569,3543]
[null,"Afra","Banana",8462,8561]
[null,"Sam","Orange",4315,5062]
[null,"Sofia","Orange",5432,6216]
[null,"Afra","Orange",1542,3697]

{"sheet":"VBA","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[]
[]
[null,"Criteria"]
[null,"Product"]
[null,"Banana"]
[]
[null,"Seller","Product","Quantity","Amount"]
[null,"Alex","Banana",2516,3054]
[null,"Sam","Banana",1565,3654]
[null,"Afra","Banana",8462,8561]

{"sheet":"pull data","index":9,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Seller","Sales Amount"]
[null,"Alex",{"$f":"VLOOKUP(B6,Dataset!B6:E13,4, TRUE)","v":3054}]
[null,"Melissa",{"$f":"VLOOKUP(B7,Dataset!B7:E14,4, TRUE)","v":8561}]