{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Go To special","Delete Option","delete sheet column","COUNTA","COUNTA and Sort","VBA","Hide Unused Column"],"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":"Dataset","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Deleting Unused Columns in Excel"]
[]
[null,"Product",null,"Product Code",null,"Color","Size","Price"]
[null,"Shirt 1",null,"EIF-CZ-73600",null,"White","L",1750]
[null,"Shirt 2",null,"EIF-CZ-97375",null,"Blue","XXL",1870]
[null,"Shirt 3",null,"EIF-A-64872",null,"Green","XL",1750]
[null,"Jacket 1",null,"EIF-CZ-48270",null,"Black","L",4500]
[null,"Jacket 2",null,"EIF-CZ-66531",null,"Brown","XL",3500]
[null,"Jacket 3",null,"10G-XF-75398",null,"Navy Blue","L",5500]
[null,"Pant 1",null,"10G-XF-96371",null,"Light Blue","XL",1200]
[null,"Pant 2",null,"10G-XF-92273",null,"Black","XXL",1230]
[null,"Pant 3",null,"E1M-SX-85914",null,"Maroon","L",1100]

{"sheet":"Go To special","index":1,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,15]]}
[]
[null,"Using Go To Special Feature",null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product","Product Code","Color","Size","Price",null,null,null,"Product",null,"Product Code",null,"Color","Size","Price"]
[null,"Shirt 1","EIF-CZ-73600","White","L",1750,null,null,null,"Shirt 1",null,"EIF-CZ-73600",null,"White","L",1750]
[null,"Shirt 2","EIF-CZ-97375","Blue","XXL",1870,null,null,null,"Shirt 2",null,"EIF-CZ-97375",null,"Blue","XXL",1870]
[null,"Shirt 3","EIF-A-64872","Green","XL",1750,null,null,null,"Shirt 3",null,"EIF-A-64872",null,"Green","XL",1750]
[null,"Jacket 1","EIF-CZ-48270","Black","L",4500,null,null,null,"Jacket 1",null,"EIF-CZ-48270",null,"Black","L",4500]
[null,"Jacket 2","EIF-CZ-66531","Brown","XL",3500,null,null,null,"Jacket 2",null,"EIF-CZ-66531",null,"Brown","XL",3500]
[null,"Jacket 3","10G-XF-75398","Navy Blue","L",5500,null,null,null,"Jacket 3",null,"10G-XF-75398",null,"Navy Blue","L",5500]
[null,"Pant 1","10G-XF-96371","Light Blue","XL",1200,null,null,null,"Pant 1",null,"10G-XF-96371",null,"Light Blue","XL",1200]
[null,"Pant 2","10G-XF-92273","Black","XXL",1230,null,null,null,"Pant 2",null,"10G-XF-92273",null,"Black","XXL",1230]
[null,"Pant 3","E1M-SX-85914","Maroon","L",1100,null,null,null,"Pant 3",null,"E1M-SX-85914",null,"Maroon","L",1100]

{"sheet":"Delete Option","index":2,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,17]]}
[]
[null,"Use of Delete Option",null,null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product","Product Code","Color","Size","Price",null,null,null,"Product",null,"Product Code",null,"Color","Size","Price"]
[null,"Shirt 1","EIF-CZ-73600","White","L",1750,null,null,null,"Shirt 1",null,"EIF-CZ-73600",null,"White","L",1750]
[null,"Shirt 2","EIF-CZ-97375","Blue","XXL",1870,null,null,null,"Shirt 2",null,"EIF-CZ-97375",null,"Blue","XXL",1870]
[null,"Shirt 3","EIF-A-64872","Green","XL",1750,null,null,null,"Shirt 3",null,"EIF-A-64872",null,"Green","XL",1750]
[null,"Jacket 1","EIF-CZ-48270","Black","L",4500,null,null,null,"Jacket 1",null,"EIF-CZ-48270",null,"Black","L",4500]
[null,"Jacket 2","EIF-CZ-66531","Brown","XL",3500,null,null,null,"Jacket 2",null,"EIF-CZ-66531",null,"Brown","XL",3500]
[null,"Jacket 3","10G-XF-75398","Navy Blue","L",5500,null,null,null,"Jacket 3",null,"10G-XF-75398",null,"Navy Blue","L",5500]
[null,"Pant 1","10G-XF-96371","Light Blue","XL",1200,null,null,null,"Pant 1",null,"10G-XF-96371",null,"Light Blue","XL",1200]
[null,"Pant 2","10G-XF-92273","Black","XXL",1230,null,null,null,"Pant 2",null,"10G-XF-92273",null,"Black","XXL",1230]
[null,"Pant 3","E1M-SX-85914","Maroon","L",1100,null,null,null,"Pant 3",null,"E1M-SX-85914",null,"Maroon","L",1100]

{"sheet":"delete sheet column","index":3,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,18]]}
[]
[null,"Employing Delete Sheet Column Feature",null,null,null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product","Product Code","Color","Size","Price",null,null,null,null,null,null,"Product",null,"Product Code",null,"Color","Size","Price"]
[null,"Shirt 1","EIF-CZ-73600","White","L",1750,null,null,null,null,null,null,"Shirt 1",null,"EIF-CZ-73600",null,"White","L",1750]
[null,"Shirt 2","EIF-CZ-97375","Blue","XXL",1870,null,null,null,null,null,null,"Shirt 2",null,"EIF-CZ-97375",null,"Blue","XXL",1870]
[null,"Shirt 3","EIF-A-64872","Green","XL",1750,null,null,null,null,null,null,"Shirt 3",null,"EIF-A-64872",null,"Green","XL",1750]
[null,"Jacket 1","EIF-CZ-48270","Black","L",4500,null,null,null,null,null,null,"Jacket 1",null,"EIF-CZ-48270",null,"Black","L",4500]
[null,"Jacket 2","EIF-CZ-66531","Brown","XL",3500,null,null,null,null,null,null,"Jacket 2",null,"EIF-CZ-66531",null,"Brown","XL",3500]
[null,"Jacket 3","10G-XF-75398","Navy Blue","L",5500,null,null,null,null,null,null,"Jacket 3",null,"10G-XF-75398",null,"Navy Blue","L",5500]
[null,"Pant 1","10G-XF-96371","Light Blue","XL",1200,null,null,null,null,null,null,"Pant 1",null,"10G-XF-96371",null,"Light Blue","XL",1200]
[null,"Pant 2","10G-XF-92273","Black","XXL",1230,null,null,null,null,null,null,"Pant 2",null,"10G-XF-92273",null,"Black","XXL",1230]
[null,"Pant 3","E1M-SX-85914","Maroon","L",1100,null,null,null,null,null,null,"Pant 3",null,"E1M-SX-85914",null,"Maroon","L",1100]

{"sheet":"COUNTA","index":4,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,17],[3,1,3,5]]}
[]
[null,"Employing COUNTA Function",null,null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Column Status"]
[null,{"$f":"IF(COUNTA(B7:B1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},{"$f":"IF(COUNTA(C7:C1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},{"$f":"IF(COUNTA(D7:D1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},{"$f":"IF(COUNTA(E7:E1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},{"$f":"IF(COUNTA(F7:F1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},null,null,null,null,null,"Product",null,"Product Code",null,"Color","Size","Price"]
[null,null,null,null,null,null,null,null,null,null,null,"Shirt 1",null,"EIF-CZ-73600",null,"White","L",1750]
[null,"Product","Product Code","Color","Size","Price",null,null,null,null,null,"Shirt 2",null,"EIF-CZ-97375",null,"Blue","XXL",1870]
[null,"Shirt 1","EIF-CZ-73600","White","L",1750,null,null,null,null,null,"Shirt 3",null,"EIF-A-64872",null,"Green","XL",1750]
[null,"Shirt 2","EIF-CZ-97375","Blue","XXL",1870,null,null,null,null,null,"Jacket 1",null,"EIF-CZ-48270",null,"Black","L",4500]
[null,"Shirt 3","EIF-A-64872","Green","XL",1750,null,null,null,null,null,"Jacket 2",null,"EIF-CZ-66531",null,"Brown","XL",3500]
[null,"Jacket 1","EIF-CZ-48270","Black","L",4500,null,null,null,null,null,"Jacket 3",null,"10G-XF-75398",null,"Navy Blue","L",5500]
[null,"Jacket 2","EIF-CZ-66531","Brown","XL",3500,null,null,null,null,null,"Pant 1",null,"10G-XF-96371",null,"Light Blue","XL",1200]
[null,"Jacket 3","10G-XF-75398","Navy Blue","L",5500,null,null,null,null,null,"Pant 2",null,"10G-XF-92273",null,"Black","XXL",1230]
[null,"Pant 1","10G-XF-96371","Light Blue","XL",1200,null,null,null,null,null,"Pant 3",null,"E1M-SX-85914",null,"Maroon","L",1100]
[null,"Pant 2","10G-XF-92273","Black","XXL",1230]
[null,"Pant 3","E1M-SX-85914","Maroon","L",1100]

{"sheet":"COUNTA and Sort","index":5,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,18],[3,1,3,5]]}
[]
[null,"Using COUNTA Function with Sot Feature",null,null,null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[]
[null,{"$f":"IF(COUNTA(B7:B1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},{"$f":"IF(COUNTA(C7:C1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},{"$f":"IF(COUNTA(D7:D1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},{"$f":"IF(COUNTA(E7:E1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},{"$f":"IF(COUNTA(F7:F1048576)=0,\"BLANK\",\"Not BLANK\")","v":"Not BLANK"},null,null,null,null,null,null,"Product",null,"Product Code",null,"Color","Size","Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shirt 1",null,"EIF-CZ-73600",null,"White","L",1750]
[null,"Product","Product Code","Color","Size","Price",null,null,null,null,null,null,"Shirt 2",null,"EIF-CZ-97375",null,"Blue","XXL",1870]
[null,"Shirt 1","EIF-CZ-73600","White","L",1750,null,null,null,null,null,null,"Shirt 3",null,"EIF-A-64872",null,"Green","XL",1750]
[null,"Shirt 2","EIF-CZ-97375","Blue","XXL",1870,null,null,null,null,null,null,"Jacket 1",null,"EIF-CZ-48270",null,"Black","L",4500]
[null,"Shirt 3","EIF-A-64872","Green","XL",1750,null,null,null,null,null,null,"Jacket 2",null,"EIF-CZ-66531",null,"Brown","XL",3500]
[null,"Jacket 1","EIF-CZ-48270","Black","L",4500,null,null,null,null,null,null,"Jacket 3",null,"10G-XF-75398",null,"Navy Blue","L",5500]
[null,"Jacket 2","EIF-CZ-66531","Brown","XL",3500,null,null,null,null,null,null,"Pant 1",null,"10G-XF-96371",null,"Light Blue","XL",1200]
[null,"Jacket 3","10G-XF-75398","Navy Blue","L",5500,null,null,null,null,null,null,"Pant 2",null,"10G-XF-92273",null,"Black","XXL",1230]
[null,"Pant 1","10G-XF-96371","Light Blue","XL",1200,null,null,null,null,null,null,"Pant 3",null,"E1M-SX-85914",null,"Maroon","L",1100]
[null,"Pant 2","10G-XF-92273","Black","XXL",1230]
[null,"Pant 3","E1M-SX-85914","Maroon","L",1100]

{"sheet":"VBA","index":6,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Inserting VBA Code",null,null,null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product","Product Code","Color","Size","Price",null,null,null,null,null,null,"Product","Product Code","Color","Size","Price"]
[null,"Shirt 1","EIF-CZ-73600","White","L",1750,null,null,null,null,null,null,"Shirt 1","EIF-CZ-73600","White","L",1750]
[null,"Shirt 2","EIF-CZ-97375","Blue","XXL",1870,null,null,null,null,null,null,"Shirt 2","EIF-CZ-97375","Blue","XXL",1870]
[null,"Shirt 3","EIF-A-64872","Green","XL",1750,null,null,null,null,null,null,"Shirt 3","EIF-A-64872","Green","XL",1750]
[null,"Jacket 1","EIF-CZ-48270","Black","L",4500,null,null,null,null,null,null,"Jacket 1","EIF-CZ-48270","Black","L",4500]
[null,"Jacket 2","EIF-CZ-66531","Brown","XL",3500,null,null,null,null,null,null,"Jacket 2","EIF-CZ-66531","Brown","XL",3500]
[null,"Jacket 3","10G-XF-75398","Navy Blue","L",5500,null,null,null,null,null,null,"Jacket 3","10G-XF-75398","Navy Blue","L",5500]
[null,"Pant 1","10G-XF-96371","Light Blue","XL",1200,null,null,null,null,null,null,"Pant 1","10G-XF-96371","Light Blue","XL",1200]
[null,"Pant 2","10G-XF-92273","Black","XXL",1230,null,null,null,null,null,null,"Pant 2","10G-XF-92273","Black","XXL",1230]
[null,"Pant 3","E1M-SX-85914","Maroon","L",1100,null,null,null,null,null,null,"Pant 3","E1M-SX-85914","Maroon","L",1100]

{"sheet":"Hide Unused Column","index":7,"n_rows":13,"n_cols":24,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,17,1,23]]}
[]
[null,"Hiding Unused Columns in Excel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Product",null,"Product Code",null,"Color","Size","Price",null,null,null,null,null,null,null,null,null,"Product",null,"Product Code",null,"Color","Size","Price"]
[null,"Shirt 1",null,"EIF-CZ-73600",null,"White","L",1750,null,null,null,null,null,null,null,null,null,"Shirt 1",null,"EIF-CZ-73600",null,"White","L",1750]
[null,"Shirt 2",null,"EIF-CZ-97375",null,"Blue","XXL",1870,null,null,null,null,null,null,null,null,null,"Shirt 2",null,"EIF-CZ-97375",null,"Blue","XXL",1870]
[null,"Shirt 3",null,"EIF-A-64872",null,"Green","XL",1750,null,null,null,null,null,null,null,null,null,"Shirt 3",null,"EIF-A-64872",null,"Green","XL",1750]
[null,"Jacket 1",null,"EIF-CZ-48270",null,"Black","L",4500,null,null,null,null,null,null,null,null,null,"Jacket 1",null,"EIF-CZ-48270",null,"Black","L",4500]
[null,"Jacket 2",null,"EIF-CZ-66531",null,"Brown","XL",3500,null,null,null,null,null,null,null,null,null,"Jacket 2",null,"EIF-CZ-66531",null,"Brown","XL",3500]
[null,"Jacket 3",null,"10G-XF-75398",null,"Navy Blue","L",5500,null,null,null,null,null,null,null,null,null,"Jacket 3",null,"10G-XF-75398",null,"Navy Blue","L",5500]
[null,"Pant 1",null,"10G-XF-96371",null,"Light Blue","XL",1200,null,null,null,null,null,null,null,null,null,"Pant 1",null,"10G-XF-96371",null,"Light Blue","XL",1200]
[null,"Pant 2",null,"10G-XF-92273",null,"Black","XXL",1230,null,null,null,null,null,null,null,null,null,"Pant 2",null,"10G-XF-92273",null,"Black","XXL",1230]
[null,"Pant 3",null,"E1M-SX-85914",null,"Maroon","L",1100,null,null,null,null,null,null,null,null,null,"Pant 3",null,"E1M-SX-85914",null,"Maroon","L",1100]