{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Error values"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Error values","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Country","Region","Person","Date","Time","Amount"]
["Belgium",{"$f":"NA()","v":{"$error":"#N/A"}},"they","2014-01-06","21:06:13",936]
["Netherlands",{"$f":"#REF!","v":{"$error":"#REF!"}},"you",{"$f":"1/0","v":{"$error":"#DIV/0!"}},"20:15:00",679]
["France",{"$f":"IF(ISNUMBER(MATCH(A4,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Non-Benelux"},"he","2014-01-08","02:56:18",691,null,null,"Wim Gielis"]
["Germany",{"$f":"IF(ISNUMBER(MATCH(A5,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Non-Benelux"},"she","2014-01-09","13:46:47",197,null,null,"2014-02-02"]
["Germany",{"$f":"IF(ISNUMBER(MATCH(A6,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Non-Benelux"},"we","2014-02-15","17:44:08.806",311,null,null,{"$f":"HYPERLINK(\"http://www.wimgielis.be\",\"Website\")","v":"Website"}]
["France",{"$f":"IF(ISNUMBER(MATCH(A7,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Non-Benelux"},"you","2014-02-16","00:47:13.936",995]
["Netherlands",{"$f":"IF(ISNUMBER(MATCH(A8,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Benelux"},"they","2014-02-17","01:00:26.680",920]
["Belgium",{"$f":"IF(ISNUMBER(MATCH(A9,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Benelux"},"I","2014-02-18","05:23:42.895",283]
["Belgium",{"$f":"IF(ISNUMBER(MATCH(A10,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Benelux"},"you","2014-02-19","23:23:13.018",928]
["Netherlands",{"$f":"IF(ISNUMBER(MATCH(A11,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Benelux"},"he",{"$error":"#N/A"},"00:00:05.379",421]
["France",{"$f":"IF(ISNUMBER(MATCH(A12,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Non-Benelux"},"she","2014-02-21","07:27:44.596",348]
["Germany",{"$f":"IF(ISNUMBER(MATCH(A13,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Non-Benelux"},"we","2014-02-22","23:08:14.184",146]
["Germany",{"$f":"IF(ISNUMBER(MATCH(A14,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Non-Benelux"},"you","2014-02-23","00:35:42.953",859]
["France",{"$f":"IF(ISNUMBER(MATCH(A15,{\"Belgium\";\"Netherlands\";\"Luxemburg\"},0)),\"Benelux\",\"Non-Benelux\")","v":"Non-Benelux"},"they","2014-02-24","01:34:43.254",820]
[]
[null,"Country","Amount"]
[null,"Belgium"]
[null,null,{"$f":"\"<\" & Contains_REF_error(A2:F2)","v":"<FALSE"},null,80]
[]
[null,"Country","Dates of the previous month"]
[null,"France",{"$f":"TEXT(D2,\"mmjjjj\") = TEXT(EOMONTH(TODAY(),-1),\"mmjjjj\")","v":true}]
[]
[null,"Has_error"]
[null,{"$f":"ISERROR(SUM(A2:F2))","v":true}]
[]
[null,"Has_REF_error"]
[null,{"$f":"ISNUMBER(MATCH(4,_xlfn.IFNA(ERROR.TYPE(A2:F2),0),0))","v":false},"==> matrix formulas will not work in the filter criteria!"]
[]
[null,{"$f":"B27","v":"Has_REF_error"}]
[null,{"$f":"COUNTIF(A2:F2,\"=#REF!\")>0","v":false}]
[]
[null,"Has_REF_Error"]
[null,{"$f":"Contains_REF_error(A2:F2)","v":false},"==> UDF's will work in the filter criteria!"]