{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Overview","Dataset","Specific Value","Table","String Value ","Non Empty Cell","First Empty Cell","Next Empty Cell","Find and Mark","Practice Section"],"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":"Overview","index":0,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,3,21,4],[22,3,22,4],[17,1,19,1],[1,1,1,4],[16,3,16,4],[17,3,17,4],[19,3,19,4],[18,3,18,4],[20,3,20,4]]}
[]
[null,"Finding Value in Column Using VBA "]
[]
[null,"Sales Person","Region","Product Name","Price"]
[null,"Adam Smith","USA","Laptop",4567]
[null,"Scott Murdock","London","iPhone",3452]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588]
[null,"Kristin Moran","Japan","Computer",6589]
[null,null,"Australia","Laptop",4999]
[null,"Elaine Gardner","Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]
[]
[null,"Find Value","Output","Formula"]
[null,"Malta",{"$f":"finding_value(C5:C15,B18)","v":"C14"},{"$f":"_xlfn.FORMULATEXT(C18)","v":"=finding_value(C5:C15,B18)"}]
[null,null,{"$f":"finding_value_in_table(\"Table\",2,B18)","v":"C14"},{"$f":"_xlfn.FORMULATEXT(C19)","v":"=finding_value_in_table(\"Table\",2,B18)"}]
[null,null,{"$f":"finding_string_in_column(C5:C15,B18)","v":"C14"},{"$f":"_xlfn.FORMULATEXT(C20)","v":"=finding_string_in_column(C5:C15,B18)"}]
[null,"Last Non Empty Cell",{"$f":"last_NonEmpty_cell(\"C\")","v":"C23"},{"$f":"_xlfn.FORMULATEXT(C21)","v":"=last_NonEmpty_cell(\"C\")"}]
[null,"First Empty Cell",{"$f":"first_empty_cell(\"B\")","v":"B1"},"=first_empty_cell(\"B\")"]
[null,"Next Empty Cell",{"$f":"next_empty_cell(B7)","v":"R10C2"},"=next_empty_cell(B7)"]

{"sheet":"Dataset","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales Data of ABC Tech Store"]
[]
[null,"Sales Person","Region","Product Name","Price"]
[null,"Adam Smith","USA","Laptop",4567]
[null,"Scott Murdock","London","iPhone",3452]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588]
[null,"Kristin Moran","Japan","Computer",6589]
[null,"Julia Johnson","Australia","Laptop",4999]
[null,"Elaine Gardner","Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]

{"sheet":"Specific Value","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Finding Specific Value"]
[]
[null,"Sales Person","Region","Product Name","Price",null,"Find Value"]
[null,"Adam Smith","USA","Laptop",4567,null,"Malta"]
[null,"Scott Murdock","London","iPhone",3452,null,"iPhone"]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588,null,{"$f":"finding_value(C5:C15,G5)","v":"C14"}]
[null,"Kristin Moran","Japan","Computer",6589]
[null,"Julia Johnson","Australia","Laptop",4999]
[null,"Elaine Gardner","Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]

{"sheet":"Table","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Locating Value in Table"]
[]
[null,"Sales Person","Region","Product Name","Price",null,"Find Value"]
[null,"Adam Smith","USA","Laptop",4567,null,"Adam Smith"]
[null,"Scott Murdock","London","iPhone",3452,null,"Jim Carry"]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588,null,{"$f":"finding_value_in_table(\"Table\",1,G5)","v":"B5"}]
[null,"Kristin Moran","Japan","Computer",6589]
[null,"Julia Johnson","Australia","Laptop",4999]
[null,"Elaine Gardner","Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]

{"sheet":"String Value ","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Searching String Value"]
[]
[null,"Sales Person","Region","Product Name","Price",null,"Find Value"]
[null,"Adam Smith","USA","Laptop",4567,null,"Computer"]
[null,"Scott Murdock","London","iPhone",3452,null,"iPhone"]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588,null,{"$f":"finding_string_in_column(D5:D15,G5)","v":"D7"}]
[null,"Kristin Moran","Japan","Computer",6589]
[null,"Julia Johnson","Australia","Laptop",4999]
[null,"Elaine Gardner","Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]

{"sheet":"Non Empty Cell","index":5,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Finding Non Empty Cell"]
[]
[null,"Sales Person","Region","Product Name","Price",null,"Column"]
[null,"Adam Smith","USA","Laptop",4567,null,"B"]
[null,"Scott Murdock","London","iPhone",3452,null,"C"]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588,null,{"$f":"last_NonEmpty_cell(G5)","v":"B16"}]
[null,"Kristin Moran","Japan","Computer",6589]
[null,"Julia Johnson","Australia","Laptop",4999]
[null,"Elaine Gardner","Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]
[null,"Tori vegas"]

{"sheet":"First Empty Cell","index":6,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Detecting First Empty Cell"]
[]
[null,"Sales Person","Region","Product Name","Price",null,"Column"]
[null,"Adam Smith","USA","Laptop",4567,null,"B"]
[null,"Scott Murdock","London","iPhone",3452,null,"C"]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588,null,{"$f":"first_empty_cell(G5)","v":"B1"}]
[null,"Kristin Moran","Japan","Computer",6589]
[null,"Julia Johnson","Australia","Laptop",4999]
[null,"Elaine Gardner","Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]

{"sheet":"Next Empty Cell","index":7,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Locating Next Empty Cell"]
[]
[null,"Sales Person","Region","Product Name","Price",null,"Next Empty Cell"]
[null,"Adam Smith","USA","Laptop",4567,null,{"$f":"next_empty_cell(B12)","v":"R16C2"}]
[null,"Scott Murdock","London","iPhone",3452]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588]
[null,"Kristin Moran","Japan","Computer",6589]
[null,"Julia Johnson","Australia","Laptop",4999]
[null,null,"Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]

{"sheet":"Find and Mark","index":8,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Finding and Marking Values"]
[]
[null,"Sales Person","Region","Product Name","Price"]
[null,"Adam Smith","USA","Laptop",4567]
[null,"Scott Murdock","London","iPhone",3452]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588]
[null,"Kristin Moran","Japan","Computer",6589]
[null,"Julia Johnson","Australia","Laptop",4999]
[null,"Elaine Gardner","Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]

{"sheet":"Practice Section","index":9,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Do It YourSelf"]
[]
[null,"Sales Person","Region","Product Name","Price",null,"Find Value"]
[null,"Adam Smith","USA","Laptop",4567,null,"Malta"]
[null,"Scott Murdock","London","iPhone",3452,null,"iPhone"]
[null,"Rachel Ross","Canada","Computer",7899]
[null,"Victor Rosario","Germany","Laptop",4588]
[null,"Kristin Moran","Japan","Computer",6589]
[null,"Julia Johnson","Australia","Laptop",4999]
[null,"Elaine Gardner","Russia","iPhone",1567]
[null,"Mary Smith","Turky","Laptop",3489]
[null,"Jonathon Swift","Poland","Computer",9243]
[null,"Jim Carry","Malta","iPhone",4567]
[null,"Nick Branson","Denmark","Laptop",8975]