{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Case-Insensitive","Case-Sensitive","COUNTIF","EXCEL 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":"Case-Insensitive","index":0,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of Excel Formula (Case-Insensitive)",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Address","Zip Code",null,null,null,null,null,"Address","Zip Code"]
[null,"328 Chauncey Street, Brooklyn",11233,null,null,null,null,null,"328 Chauncey Street, Brooklyn",11233]
[null,"1049 Park Avenue, New York",10028,null,null,null,null,null,"1049 Park Avenue, New York",10028]
[null,"69 park Street, Pittsford",5763,null,null,null,null,null,"69 park Street, Pittsford",5763]
[null,"1600 Pennsylvania Avenue, Washington, DC",20500,null,null,null,null,null,"1600 Pennsylvania Avenue, Washington, DC",20500]
[null,"Laughing J Ranch, Phippsburg, New York",15213,null,null,null,null,null,"Laughing J Ranch, Phippsburg, New York",15213]
[null,"103 Manhattan Park, New York",1633,null,null,null,null,null,"103 Manhattan Park, New York",1633]
[]
[null,"Input Word","New York",null,null,null,null,null,"Input Word","New York"]
[null,"Total SUMPRODUCT",{"$f":"SUMPRODUCT((LEN(B5:C10)-LEN(SUBSTITUTE(B5:C10,C12,\"\")))/LEN(C12))","v":3},null,null,null,null,null,"Total SUMPRODUCT",{"$f":"SUMPRODUCT((LEN(I5:J10)-\nLEN(SUBSTITUTE(I5:J10,J12,\"\")))/LEN(J12))","v":3}]

{"sheet":"Case-Sensitive","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of Excel Formula (Case-Sensitive)",null,null,null,null,null,"Try Yourself"]
[]
[null,"Address","Zip Code",null,null,null,null,"Address","Zip Code"]
[null,"328 Chauncey Street, Brooklyn",11233,null,null,null,null,"328 Chauncey Street, Brooklyn",11233]
[null,"1049 Park Avenue, New York",10028,null,null,null,null,"1049 Park Avenue, New York",10028]
[null,"69 park Street, Pittsford",5763,null,null,null,null,"69 park Street, Pittsford",5763]
[null,"1600 Pennsylvania Avenue, Washington, DC",20500,null,null,null,null,"1600 Pennsylvania Avenue, Washington, DC",20500]
[null,"Laughing J Ranch, Phippsburg, New York",15213,null,null,null,null,"Laughing J Ranch, Phippsburg, New York",15213]
[null,"103 Manhattan Park, New York",1633,null,null,null,null,"103 Manhattan Park, New York",1633]
[]
[null,"Input Word","Park",null,null,null,null,"Input Word","Park"]
[null,"Total SUMPRODUCT",{"$f":"SUMPRODUCT((LEN(B5:C10)-LEN(SUBSTITUTE((UPPER(B5:C10)),UPPER(C12),\"\")))/LEN(C12))","v":3},null,null,null,null,"Total SUMPRODUCT",{"$f":"SUMPRODUCT((LEN(H5:I10)-LEN(SUBSTITUTE((UPPER(H5:I10)),UPPER(I12),\"\")))/LEN(I12))","v":3}]

{"sheet":"COUNTIF","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of COUNTIF Function",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Address","Zip Code",null,null,null,null,null,null,null,null,"Address","Zip Code"]
[null,"Brooklyn",11233,null,null,null,null,null,null,null,null,"Brooklyn",11233]
[null,"New York",1633,null,null,null,null,null,null,null,null,"New York",1633]
[null,"Pittsford",5763,null,null,null,null,null,null,null,null,"Pittsford",5763]
[null,"Washington DC",20500,null,null,null,null,null,null,null,null,"Washington DC",20500]
[null,"Texas",15213,null,null,null,null,null,null,null,null,"Texas",15213]
[null,"New York",1633,null,null,null,null,null,null,null,null,"New York",1633]
[]
[null,"Input Word",1633,null,null,null,null,null,null,null,null,"Input Word",1633]
[null,"Total Count",{"$f":"COUNTIF(B5:C10,C12)","v":2},null,null,null,null,null,null,null,null,"Total Count",{"$f":"COUNTIF(L5:M10,M12)","v":2}]

{"sheet":"EXCEL VBA","index":3,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Address","Zip Code",null,null,null,null,null,null,null,null,null,"Address","Zip Code"]
[null,"Brooklyn",11233,null,null,null,null,null,null,null,null,null,"Brooklyn",11233]
[null,"New York",1633,null,null,null,null,null,null,null,null,null,"New York",1633]
[null,"Pittsford",5763,null,null,null,null,null,null,null,null,null,"Pittsford",5763]
[null,"Washington DC",20500,null,null,null,null,null,null,null,null,null,"Washington DC",20500]
[null," New York",1633,null,null,null,null,null,null,null,null,null," New York",1633]
[null,"New York",1633,null,null,null,null,null,null,null,null,null,"New York",1633]
[]
[null,"Input Word","New York",null,null,null,null,null,null,null,null,null,"Input Word","New York"]
[null,"Total Count",2,null,null,null,null,null,null,null,null,null,"Total Count",2]