{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Duplicates","Formula","MsgBox","Order"],"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":"Duplicates","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Count Duplicates with VBA"]
[]
[null,"Random Numbers",null,"Number to Check","Count"]
[null,2846,null,2473,3]
[null,1363]
[null,2473]
[null,8526]
[null,7327]
[null,2473]
[null,9637]
[null,3484]
[null,2473]
[null,5820]
[null,6395]

{"sheet":"Formula","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Count Duplicates with Formula in VBA"]
[]
[null,"Random Numbers",null,"Number to Check","Count"]
[null,2846,null,2473,{"$f":"COUNTIF(B5:B15,D5)","v":3}]
[null,1363]
[null,2473]
[null,8526]
[null,7327]
[null,2473]
[null,9637]
[null,3484]
[null,2473]
[null,5820]
[null,6395]

{"sheet":"MsgBox","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Duplicates in MsgBox with VBA"]
[]
[null,"Random Numbers"]
[null,2846]
[null,1363]
[null,2473]
[null,8526]
[null,7327]
[null,2473]
[null,9637]
[null,3484]
[null,2473]
[null,5820]
[null,6395]

{"sheet":"Order","index":3,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Count Duplicates in Order with VBA"]
[]
[null,"Random Numbers","Number of Duplicates"]
[null,2846,1]
[null,1363,1]
[null,2473,1]
[null,8526,1]
[null,7327,1]
[null,2473,2]
[null,9637,1]
[null,3484,1]
[null,2473,3]
[null,5820,1]
[null,6395,1]