{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","FindIntegerValueCellAddress","GettingStringValueCellAddress","All Cell Addresses for Integer","All Cell Addresses for String","Use of ADDRESS Function","Utilizing CELL Function","Get Row and Col No from Address","Row and Col No from Selection","Row and Col No Based on Value","Get Row and Column Using SPLIT ","Set Variable to Cell Address","Value Insertion by Active Cell"],"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":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sales Data"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP001","Alex","Fridge","PI102",200]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"FindIntegerValueCellAddress","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Cell Address Based on Integer Value"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP001","Alex","Fridge","PI102",200]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"GettingStringValueCellAddress","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Getting Cell Address Based on String Value"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP001","Alex","Fridge","PI102",200]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"All Cell Addresses for Integer","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding All Cell Addresses of Duplicate Integer Value"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP001","Alex","Fridge","PI102",200]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"All Cell Addresses for String","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Getting All Cell Addresses of Repeated String Value"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP001","Alex","Fridge","PI102",200]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"Use of ADDRESS Function","index":5,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,9,4,10],[5,7,5,10],[1,1,1,10]]}
[]
[null,"Using ADDRESS Function to Get Cell Address Based on Value"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales",null,"Value","David","Address of Cell that contains the Value"]
[null,"SP001","Alex","TV","PI101",100,null,"Address",{"$f":"ADDRESS(MATCH(I4, C:C, 0), COLUMN(C5))","v":"$C$8"}]
[null,"SP001","Alex","Fridge","PI102",200,null,{"$f":"_xlfn.FORMULATEXT(I5)","v":"=ADDRESS(MATCH(I4, C:C, 0), COLUMN(C5))"}]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"Utilizing CELL Function","index":6,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,10],[3,9,4,10],[5,7,6,10]]}
[]
[null,"Utilizing CELL Function to Get Cell Address Based on Value"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales",null,"Value","Megan","Address of Cell that contains the Value"]
[null,"SP001","Alex","TV","PI101",100,null,"Address",{"$f":"CELL(\"address\",INDEX($C$4:$F$13,MATCH($I$4,$C$4:$C$13,0),1))","v":"$C$11"}]
[null,"SP001","Alex","Fridge","PI102",200,null,{"$f":"_xlfn.FORMULATEXT(I5)","v":"=CELL(\"address\",INDEX($C$4:$F$13,MATCH($I$4,$C$4:$C$13,0),1))"}]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"Get Row and Col No from Address","index":7,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,10],[3,9,4,10],[5,7,6,10]]}
[]
[null,"Getting Row and Column Number from Cell Address"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales",null,"Value","Megan","Address of Cell that contains the Value"]
[null,"SP001","Alex","TV","PI101",100,null,"Address",{"$f":"CELL(\"address\",INDEX($C$4:$F$13,MATCH($I$4,$C$4:$C$13,0),1))","v":"$C$11"}]
[null,"SP001","Alex","Fridge","PI102",200,null,{"$f":"_xlfn.FORMULATEXT(I5)","v":"=CELL(\"address\",INDEX($C$4:$F$13,MATCH($I$4,$C$4:$C$13,0),1))"}]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"Row and Col No from Selection","index":8,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Row and Column Number from Selection"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP001","Alex","Fridge","PI102",200]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"Row and Col No Based on Value","index":9,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Row and Column Number Based on Value"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP001","Alex","Fridge","PI102",200]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"Get Row and Column Using SPLIT ","index":10,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,10],[3,9,4,10],[5,7,6,10]]}
[]
[null,"Getting Row and Column from Cell Address Using SPLIT Function"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales",null,"Value","Megan","Address of Cell that contains the Value"]
[null,"SP001","Alex","TV","PI101",100,null,"Address",{"$f":"CELL(\"address\",INDEX($C$4:$F$13,MATCH($I$4,$C$4:$C$13,0),1))","v":"$C$11"}]
[null,"SP001","Alex","Fridge","PI102",200,null,{"$f":"_xlfn.FORMULATEXT(I5)","v":"=CELL(\"address\",INDEX($C$4:$F$13,MATCH($I$4,$C$4:$C$13,0),1))"}]
[null,"SP001","Alex","Phone","PI103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"Set Variable to Cell Address","index":11,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Setting Variable to Cell Address"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP001","Alex","Fridge","P102",200]
[null,"SP001","Alex","Phone","P103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]

{"sheet":"Value Insertion by Active Cell","index":12,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Inserting Value to a Cell Based on Address"]
[]
[null,"Salesperson ID","Salesperson","Product","Product ID","Total Sales"]
[null,"SP001","Alex","TV","PI101",100]
[null,"SP001","Alex","Fridge"]
[null,"SP001","Alex","Phone","P103",150]
[null,"SP002","David","TV","PI101",75]
[null,"SP002","David","Fridge","PI102",300]
[null,"SP002","David","Phone","PI103",50]
[null,"SP003","Megan","TV","PI101",150]
[null,"SP003","Megan","Fridge","PI102",100]
[null,"SP003","Megan","Phone","PI103",175]