{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ADDRESS","INDEX","INDIRECT","MAX & MIN","Column Letter","VBA"],"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":"ADDRESS","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using ADDRESS Function"]
[]
[null,"Items","Find 1",{"$f":"INDIRECT(ADDRESS(10,2))","v":"Binoculars"}]
[null,"USB Fan"]
[null,"WiFi Router","Find 2",{"$f":"INDIRECT(ADDRESS(8,2))","v":"USB Hub"}]
[null,"USB Charger"]
[null,"USB Hub"]
[null,"Security Camera"]
[null,"Binoculars"]

{"sheet":"INDEX","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using INDEX Function"]
[]
[null,"Items","Row",4]
[null,"USB Fan","Column",1]
[null,"WiFi Router","Find",{"$f":"INDEX(B4:D10,4,1)","v":"USB Charger"}]
[null,"USB Charger"]
[null,"USB Hub"]
[null,"Security Camera"]
[null,"Binoculars"]

{"sheet":"INDIRECT","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using INDIRECT Function"]
[]
[null,"Items","Row",5]
[null,"USB Fan","Column",2]
[null,"WiFi Router","Find",{"$f":"INDIRECT(\"R\" & D4 & \"C\" & D5,FALSE)","v":"USB Fan"}]
[null,"USB Charger"]
[null,"USB Hub"]
[null,"Security Camera"]
[null,"Binoculars"]

{"sheet":"MAX & MIN","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining MAX and MIN Functions"]
[]
[null,"Items","Sales (units)","Max",{"$f":"MAX(C5:C10)","v":500}]
[null,"USB Fan",500,"Min",{"$f":"MIN(C5:C10)","v":130}]
[null,"WiFi Router",150]
[null,"USB Charger",370]
[null,"USB Hub",200]
[null,"Security Camera",130]
[null,"Binoculars",460]

{"sheet":"Column Letter","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Finding Cell Column Letter"]
[]
[null,"Column Number","Column Letter"]
[null,5,{"$f":"SUBSTITUTE(ADDRESS(5,B5,4),\"5\",\"\")","v":"E"}]
[null,23,{"$f":"SUBSTITUTE(ADDRESS(5,B6,4),\"5\",\"\")","v":"W"}]
[null,15,"O"]
[null,7,"G"]
[null,30,"AD"]
[null,20,"T"]

{"sheet":"VBA","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code"]
[]
[null,"Items","Row",5]
[null,"USB Fan","Column",2]
[null,"WiFi Router","Find",{"$f":"CellValue(D4,D5)","v":"USB Fan"}]
[null,"USB Charger"]
[null,"USB Hub"]
[null,"Security Camera"]
[null,"Binoculars"]