{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ISFORMULA and FILTER","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"ISFORMULA and FILTER","index":0,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Use of ISFORMULA and FILTER Functions",null,null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Values","Percentage","Output",null,null,null,null,null,null,"Values","Percentage","Output"]
[null,200,0.1,{"$f":"B5*C5","v":20},null,null,null,null,null,null,200,0.1,{"$f":"K5*L5","v":20}]
[null,100,0.4,40,null,null,null,null,null,null,100,0.4,40]
[null,400,0.5,{"$f":"B7*C7","v":200},null,null,null,null,null,null,400,0.5,{"$f":"K7*L7","v":200}]
[null,300,0.3,90,null,null,null,null,null,null,300,0.3,90]
[null,50,0.6,30,null,null,null,null,null,null,50,0.6,30]
[null,150,0.8,{"$f":"B10*C10","v":120},null,null,null,null,null,null,150,0.8,{"$f":"K10*L10","v":120}]
[null,280,0.9,{"$f":"B11*C11","v":252},null,null,null,null,null,null,280,0.9,{"$f":"K11*L11","v":252}]
[]
[null,"Values","Percentage","Output",null,null,null,null,null,null,"Values","Percentage","Output"]
[null,{"$f":"_xlfn._xlws.FILTER(B5:D11,--_xlfn.ISFORMULA(D5:D11)=1,\"Not Found\")","v":200},0.1,20]
[null,400,0.5,200]
[null,150,0.8,120]
[null,280,0.9,252]

{"sheet":"VBA","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of VBA"]
[]
[null,"Values","Percentage","Output","Contains Formula?"]
[null,200,0.1,{"$f":"B5*C5","v":20},{"$f":"HasFormula(D5)","v":true}]
[null,100,0.4,40,{"$f":"HasFormula(D6)","v":false}]
[null,400,0.5,{"$f":"B7*C7","v":200},{"$f":"HasFormula(D7)","v":true}]
[null,300,0.3,90,{"$f":"HasFormula(D8)","v":false}]
[null,50,0.6,30,{"$f":"HasFormula(D9)","v":false}]
[null,150,0.8,{"$f":"B10*C10","v":120},{"$f":"HasFormula(D10)","v":true}]
[null,280,0.9,{"$f":"B11*C11","v":252},{"$f":"HasFormula(D11)","v":true}]