{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Find Value in Column","Table Column","Find Text in Column","Find Non Empty Cell","Find First Empty Cell Column","Find 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":"Dataset","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["VBA Find Value in Column"]
[]
[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":"Find Value in Column","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Find Value in Column"]
[]
[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":"FindValueInColumn(C4:C14,G4)","v":"C13"}]
[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 Column","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Find Value in Table Column"]
[]
[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":"FindValueInTableColumn(\"Table Column\",1,G4)","v":"B4"}]
[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":"Find Text in Column","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
[" Find String Value in Column"]
[]
[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":"FindStringInColumn(D4:D14,G4)","v":"D6"}]
[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":"Find Non Empty Cell","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Find Non Empty Cell in Column"]
[]
[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":"FindLastNonEmptyCellColumn(G4)","v":"B15"}]
[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":"Find First Empty Cell Column","index":5,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Find First Empty Cell in Column"]
[]
[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":"FindFirstEmptyCellColumn(G4)","v":"B2"}]
[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":"Find Next Empty Cell","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Find Next Empty Cell in Column"]
[]
[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,{"$f":"FindNextEmptyCellColumn(B12)","v":"R15C2"}]
[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":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["VBA Find and Mark Value in Column"]
[]
[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":8,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["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]