{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Dataset","Filter Op_Source","Filter Op_Destination","Advanced_Source","Advanced_Destination","Array Formula","Rooted","Ambrosia","Fruity","VitaPure","Functions_Source","Functions_Destination","FILTER_Source","FILTER_Destination","VBA_Source","VBA_Destination"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset for Copying Rows from One Sheet to Another"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,"Cherry\t",25,5,{"$f":"C5*D5","v":125}]
[null,"Lemon",14,10,{"$f":"C6*D6","v":140}]
[null,"Mango ",19,6,114]
[null,"Orange",25,7,175]
[null,"Apple",35,11,385]

{"sheet":"Filter Op_Source","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Filter Option"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,"Cherry\t",25,5,{"$f":"C5*D5","v":125}]
[null,"Lemon",14,10,{"$f":"C6*D6","v":140}]
[null,"Mango ",19,6,114]
[null,"Orange",25,7,175]
[null,"Apple",35,11,385]

{"sheet":"Filter Op_Destination","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Filter Option"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,"Cherry\t",25,5,125]
[null,"Lemon",14,10,140]
[null,"Apple",35,11,385]

{"sheet":"Advanced_Source","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Advanced Feature"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,"Cherry\t",25,5,{"$f":"C5*D5","v":125}]
[null,"Lemon",14,10,{"$f":"C6*D6","v":140}]
[null,"Mango ",19,6,114]
[null,"Orange",25,7,175]
[null,"Apple",35,11,385]
[]
[null,"Total Price "]
[null,">150"]

{"sheet":"Advanced_Destination","index":4,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Advanced Feature"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,"Orange",25,7,175]
[null,"Apple",35,11,385]

{"sheet":"Array Formula","index":5,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Array Formula"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price ","Shop Names"]
[null,"Cherry\t",25,5,{"$f":"C5*D5","v":125},"Rooted"]
[null,"Lemon",14,10,{"$f":"C6*D6","v":140},"Ambrosia"]
[null,"Mango ",19,6,114,"Fruity"]
[null,"Orange",25,7,175,"VitaPure"]
[null,"Apple",35,11,385,"Ambrosia"]
[null,"Papaya",75,14,1050,"Rooted"]
[null,"Watermelon",14.5,10,145,"Fruity"]
[null,"Mulberry",11.5,17,195.5,"Fruity"]
[null,"Pear",9.99,15,149.85,"Rooted"]
[null,"Olive\t",7.5,16,120,"Rooted"]
[null,"CLEMENTINE",25,25,625,"Rooted"]

{"sheet":"Rooted","index":6,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Array Formula"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":"Cherry\t"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":25},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":5},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":125}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":"Papaya"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":75},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":14},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":1050}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":"Pear"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":9.99},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":15},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":149.85}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":"Olive\t"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":7.5},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":16},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":120}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":"CLEMENTINE"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":25},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":25},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":625}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""}]
[]
[null,"Criteria","Rooted"]

{"sheet":"Ambrosia","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Array Formula"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":"Lemon"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":14},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":10},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":140}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":"Apple"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":35},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":11},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":385}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""}]
[]
[null,"Criteria","Ambrosia"]

{"sheet":"Fruity","index":8,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Array Formula"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":"Mango "},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":19},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":6},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":114}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":"Watermelon"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":14.5},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":10},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":145}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":"Mulberry"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":11.5},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":17},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":195.5}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""}]
[]
[null,"Criteria","Fruity"]

{"sheet":"VitaPure","index":9,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Array Formula"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":"Orange"},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":25},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":7},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B5)),COLUMN()),\"\")","v":175}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B6)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B7)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B8)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B9)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B10)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B11)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B12)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B13)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B14)),COLUMN()),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""},{"$f":"IFERROR(INDEX('Array Formula'!$A$5:$E$101,SMALL(IF('Array Formula'!$F$5:$F$101=$C$17,ROW('Array Formula'!$A$5:$B$101)-ROW('Array Formula'!$B$5)+1),ROWS('Array Formula'!$A$5:$B15)),COLUMN()),\"\")","v":""}]
[]
[null,"Criteria","VitaPure"]

{"sheet":"Functions_Source","index":10,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of Excel Functions"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price ","Shop Names","Sequence "]
[null,"Cherry\t",25,5,{"$f":"C5*D5","v":125},"Rooted",{"$f":"IF(AND(F5=Functions_Destination!$C$4,E5>=130),MAX(G$2:G3)+1,\"-\")","v":"-"}]
[null,"Lemon",14,10,{"$f":"C6*D6","v":140},"Ambrosia",{"$f":"IF(AND(F6=Functions_Destination!$C$4,E6>=130),MAX(G$2:G4)+1,\"-\")","v":"-"}]
[null,"Mango ",19,6,114,"Fruity",{"$f":"IF(AND(F7=Functions_Destination!$C$4,E7>=130),MAX(G$2:G5)+1,\"-\")","v":"-"}]
[null,"Orange",25,7,175,"VitaPure",{"$f":"IF(AND(F8=Functions_Destination!$C$4,E8>=130),MAX(G$2:G6)+1,\"-\")","v":"-"}]
[null,"Apple",35,11,385,"Ambrosia",{"$f":"IF(AND(F9=Functions_Destination!$C$4,E9>=130),MAX(G$2:G7)+1,\"-\")","v":"-"}]
[null,"Papaya",80,14,1120,"Rooted",{"$f":"IF(AND(F10=Functions_Destination!$C$4,E10>=130),MAX(G$2:G8)+1,\"-\")","v":1}]
[null,"Watermelon",14.5,10,145,"Fruity",{"$f":"IF(AND(F11=Functions_Destination!$C$4,E11>=130),MAX(G$2:G9)+1,\"-\")","v":"-"}]
[null,"Mulberry",11.5,17,195.5,"Fruity",{"$f":"IF(AND(F12=Functions_Destination!$C$4,E12>=130),MAX(G$2:G10)+1,\"-\")","v":"-"}]
[null,"Pear",9.99,15,149.85,"Rooted",{"$f":"IF(AND(F13=Functions_Destination!$C$4,E13>=130),MAX(G$2:G11)+1,\"-\")","v":2}]
[null,"Olive\t",7.5,16,120,"Rooted",{"$f":"IF(AND(F14=Functions_Destination!$C$4,E14>=130),MAX(G$2:G12)+1,\"-\")","v":"-"}]

{"sheet":"Functions_Destination","index":11,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Excel Functions"]
[]
[null,"Enter Shop Name","Rooted",null,"Shop Names"]
[null,null,null,null,"Rooted"]
[null,"Shop Names","Fruits",null,"Ambrosia"]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:4),Functions_Source!$G:$G,0))&\"\",\"\")","v":"Rooted"},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:4),Functions_Source!$G:$G,0))&\"\",\"\")","v":"Papaya"},null,"Fruity"]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:5),Functions_Source!$G:$G,0))&\"\",\"\")","v":"Rooted"},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:5),Functions_Source!$G:$G,0))&\"\",\"\")","v":"Pear"},null,"VitaPura"]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:6),Functions_Source!$G:$G,0))&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:6),Functions_Source!$G:$G,0))&\"\",\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:7),Functions_Source!$G:$G,0))&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:7),Functions_Source!$G:$G,0))&\"\",\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:8),Functions_Source!$G:$G,0))&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:8),Functions_Source!$G:$G,0))&\"\",\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:9),Functions_Source!$G:$G,0))&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:9),Functions_Source!$G:$G,0))&\"\",\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:10),Functions_Source!$G:$G,0))&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:10),Functions_Source!$G:$G,0))&\"\",\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:11),Functions_Source!$G:$G,0))&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:11),Functions_Source!$G:$G,0))&\"\",\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:12),Functions_Source!$G:$G,0))&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:12),Functions_Source!$G:$G,0))&\"\",\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Functions_Source!F:F,MATCH(ROWS($4:13),Functions_Source!$G:$G,0))&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(Functions_Source!B:B,MATCH(ROWS($4:13),Functions_Source!$G:$G,0))&\"\",\"\")","v":""}]

{"sheet":"FILTER_Source","index":12,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of FILTER Function"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price ","Shop Names"]
[null,"Cherry\t",25,5,{"$f":"C5*D5","v":125},"Rooted"]
[null,"Lemon",14,10,140,"Ambrosia"]
[null,"Mango ",19,6,114,"Fruity"]
[null,"Orange",25,7,175,"VitaPure"]
[null,"Apple",35,11,385,"Ambrosia"]
[null,"Papaya",80,14,1120,"Rooted"]
[null,"Watermelon",14.5,10,145,"Fruity"]
[null,"Mulberry",11.5,17,195.5,"Fruity"]
[null,"Pear",9.99,15,149.85,"Rooted"]
[null,"Olive\t",7.5,16,120,"Rooted"]

{"sheet":"FILTER_Destination","index":13,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of FILTER Function"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price ","Shop Names"]
[null,{"$f":"_xlfn._xlws.FILTER(FILTER_Source!B4:F14,FILTER_Source!F4:F14=\"Rooted\")","v":"Cherry\t"},25,5,125,"Rooted"]
[null,"Papaya",80,14,1120,"Rooted"]
[null,"Pear",9.99,15,149.85,"Rooted"]
[null,"Olive\t",7.5,16,120,"Rooted"]

{"sheet":"VBA_Source","index":14,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Excel VBA"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,"Cherry\t",25,5,{"$f":"C5*D5","v":125}]
[null,"Lemon",14,10,{"$f":"C6*D6","v":140}]
[null,"Mango ",19,6,114]
[null,"Orange",25,7,175]
[null,"Apple",35,11,385]

{"sheet":"VBA_Destination","index":15,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Excel VBA"]
[]
[null,"Fruits","Unit Price(USD)","Weight(Kg)","Total Price "]
[null,"Orange",25,7,{"$f":"C5*D5","v":175}]
[null,"Apple",35,11,385]