{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["sbMiniPivot"],"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":"sbMiniPivot","index":0,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Input"]
["a",1,"a"]
["a",2,"b"]
["a",3,"c"]
["b",4,"d"]
["b",5,"e"]
["c",6,"f"]
["c",7,"g"]
["c",8,"h"]
["c",9,"i"]
[]
["Output numerical minimum",null,null,"Output string minimum"]
[{"$f":"sbMiniPivot(\"min\", A2:A10<>\"c\", A2:A10,B2:B10)","v":"a"},1,{"$f":"sbGetCell(A13,\"FormulaWOT\")","v":"=sbMiniPivot(\"min\", A2:A10<>\"c\", A2:A10,B2:B10)"},{"$f":"sbMiniPivot(\"min\",A2:A10<>\"c\", A2:A10,C2:C10)","v":"a"},"a",{"$f":"sbGetCell(D13,\"FormulaWOT\")","v":"=sbMiniPivot(\"min\",A2:A10<>\"c\", A2:A10,C2:C10)"}]
["b",4,null,"b","d"]
[]
["Output numerical maximum",null,null,"Output string maximum"]
[{"$f":"sbMiniPivot(\"max\",A2:A10<>\"b\", A2:A10,B2:B10)","v":"a"},3,{"$f":"sbGetCell(A17,\"FormulaWOT\")","v":"=sbMiniPivot(\"max\",A2:A10<>\"b\", A2:A10,B2:B10)"},{"$f":"sbMiniPivot(\"max\",A2:A10<>\"b\", A2:A10,C2:C10)","v":"a"},"c",{"$f":"sbGetCell(D17,\"FormulaWOT\")","v":"=sbMiniPivot(\"max\",A2:A10<>\"b\", A2:A10,C2:C10)"}]
["c",9,null,"c","i"]
[]
["Output numerical sum"]
[{"$f":"sbMiniPivot(\"sum\", TRUE,A2:A10,B2:B10)","v":"a"},6,{"$f":"sbGetCell(A21,\"FormulaWOT\")","v":"=sbMiniPivot(\"sum\", TRUE,A2:A10,B2:B10)"}]
["b",9]
["c",30]