{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Approach 1.1","Approach 1.2","Approach 2","Approach 3","Approach 4","VBA"],"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","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Auto Sort in Excel When Data is Entered "]
[]
[null,"Name","Total Marks"]
[null,"james ",900]
[null,"Rose",750]
[null,"Bell",820]
[null,"Frank ",940]
[null,"George",778]
[null,"Robert",840]

{"sheet":"Approach 1.1","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5]]}
[]
[]
[null,"Auto Sort in Excel When Data is Entered ",null,null,"Sorted Condition"]
[]
[null,"Name","Total Marks",null,"Name","Total Marks"]
[null,"James ",900,null,{"$f":"_xlfn._xlws.SORT(B6:C11,2,1)","v":"Rose"},750]
[null,"Rose",750,null,"George",778]
[null,"Bell",820,null,"Bell",820]
[null,"Frank ",940,null,"Robert",840]
[null,"George",778,null,"James ",900]
[null,"Robert",840,null,"Frank ",940]

{"sheet":"Approach 1.2","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5]]}
[]
[]
[null,"Auto Sort in Excel When Data is Entered ",null,null,"Sorted Condition"]
[]
[null,"Name","Total Marks",null,"Name","Total Marks"]
[null,"James ",900,null,{"$f":"_xlfn._xlws.SORT(B6:C11,2,-1)","v":"Frank "},940]
[null,"Rose",750,null,"James ",900]
[null,"Bell",820,null,"Robert",840]
[null,"Frank ",940,null,"Bell",820]
[null,"George",778,null,"George",778]
[null,"Robert",840,null,"Rose",750]

{"sheet":"Approach 2","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5]]}
[]
[]
[null,"Auto Sort in Excel When Data is Entered ",null,null,"Sorted Condition"]
[]
[null,"Name","Total Marks",null,"Name","Total Marks"]
[null,"James ",900,null,{"$f":"_xlfn._xlws.SORT(B6:C11,{1,2},{1,1})","v":"Bell"},820]
[null,"Rose",750,null,"Frank ",940]
[null,"Bell",820,null,"George",778]
[null,"Frank ",940,null,"James ",900]
[null,"George",778,null,"Robert",840]
[null,"Robert",840,null,"Rose",750]

{"sheet":"Approach 3","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5]]}
[]
[]
[null,"Auto Sort in Excel When Data is Entered ",null,null,"Sorted Condition"]
[]
[null,"Name","Total Marks",null,"Name","Total Marks"]
[null,"James ",900,null,{"$f":"_xlfn._xlws.SORT(_xlfn._xlws.FILTER(B6:C11,C6:C11>=C10),2)","v":"George"},778]
[null,"Rose",750,null,"Bell",820]
[null,"Bell",820,null,"Robert",840]
[null,"Frank ",940,null,"James ",900]
[null,"George",778,null,"Frank ",940]
[null,"Robert",840]

{"sheet":"Approach 4","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5]]}
[]
[]
[null,"Auto Sort in Excel When Data is Entered ",null,null,"Sorted Condition"]
[]
[null,"Name","Total Marks",null,"Name","Total Marks"]
[null,"James ",900,null,{"$f":"INDEX(_xlfn._xlws.SORT(B6:C11,2,1),_xlfn.SEQUENCE(6),{1,2})","v":"Rose"},750]
[null,"Rose",750,null,"George",778]
[null,"Bell",820,null,"Bell",820]
[null,"Frank ",940,null,"Robert",840]
[null,"George",778,null,"James ",900]
[null,"Robert",840,null,"Frank ",940]

{"sheet":"VBA","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Auto Sort in Excel When Data is Entered "]
[]
[null,"Name","Total Marks"]
[null,"Bell",820]
[null,"Finch",778]
[null,"Frank ",940]
[null,"James ",900]
[null,"Robert",840]
[null,"Rose",750]