{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","COLUMN & INDIRECT","MATCH, ADDRESS, COLUMN","Specific Cell","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":"Dataset","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Converting Column Letter to Number Chart"]
[]
[null,"Letter","Number"]
[null,"A"]
[null,"F"]
[null,"T"]
[null,"IA"]
[null,"TA"]
[null,"ABC"]
[null,"XBL"]

{"sheet":"COLUMN & INDIRECT","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Combining COLUMN & INDIRECT Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Letter","Number",null,null,null,"Letter","Number"]
[null,"A",{"$f":"COLUMN(INDIRECT(B5&\"1\"))","v":1},null,null,null,"A"]
[null,"F",{"$f":"COLUMN(INDIRECT(B6&\"1\"))","v":6},null,null,null,"F"]
[null,"T",{"$f":"COLUMN(INDIRECT(B7&\"1\"))","v":20},null,null,null,"T"]
[null,"IA",{"$f":"COLUMN(INDIRECT(B8&\"1\"))","v":235},null,null,null,"IA"]
[null,"TA",{"$f":"COLUMN(INDIRECT(B9&\"1\"))","v":521},null,null,null,"TA"]
[null,"ABC",{"$f":"COLUMN(INDIRECT(B10&\"1\"))","v":731},null,null,null,"ABC"]
[null,"XBL",{"$f":"COLUMN(INDIRECT(B11&\"1\"))","v":16288},null,null,null,"XBL"]

{"sheet":"MATCH, ADDRESS, COLUMN","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Applying MATCH, ADDRESS & COLUMN Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Letter","Number",null,null,null,null,"Letter","Number"]
[null,"A",{"$f":"MATCH(B5&\"1\", ADDRESS(1, COLUMN($1:$1), 4), 0)","v":1},null,null,null,null,"A"]
[null,"F",{"$f":"MATCH(B6&\"1\", ADDRESS(1, COLUMN($1:$1), 4), 0)","v":6},null,null,null,null,"F"]
[null,"T",{"$f":"MATCH(B7&\"1\", ADDRESS(1, COLUMN($1:$1), 4), 0)","v":20},null,null,null,null,"T"]
[null,"IA",{"$f":"MATCH(B8&\"1\", ADDRESS(1, COLUMN($1:$1), 4), 0)","v":235},null,null,null,null,"IA"]
[null,"TA",{"$f":"MATCH(B9&\"1\", ADDRESS(1, COLUMN($1:$1), 4), 0)","v":521},null,null,null,null,"TA"]
[null,"ABC",{"$f":"MATCH(B10&\"1\", ADDRESS(1, COLUMN($1:$1), 4), 0)","v":731},null,null,null,null,"ABC"]
[null,"XBL",{"$f":"MATCH(B11&\"1\", ADDRESS(1, COLUMN($1:$1), 4), 0)","v":16288},null,null,null,null,"XBL"]

{"sheet":"Specific Cell","index":3,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using COLUMN Function",null,null,null,null,null,"Do Yourself"]
[]
[null,"Letter","Number",null,null,null,null,"Letter","Number"]
[null,"A1",{"$f":"COLUMN(A1)","v":1},null,null,null,null,"A1"]
[null,"F5",{"$f":"COLUMN(F5)","v":6},null,null,null,null,"F5"]
[null,"T5",{"$f":"COLUMN(T5)","v":20},null,null,null,null,"T5"]
[null,"IA9",{"$f":"COLUMN(IA9)","v":235},null,null,null,null,"IA9"]
[null,"TA23",{"$f":"COLUMN(TA23)","v":521},null,null,null,null,"TA23"]
[null,"ABC5",{"$f":"COLUMN(ABC5)","v":731},null,null,null,null,"ABC5"]
[null,"XBL7",{"$f":"COLUMN(XBL7)","v":16288},null,null,null,null,"XBL7"]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Applying User-Defined Function",null,null,null,null,null,"Do Yourself"]
[]
[null,"Letter","Number",null,null,null,null,"Letter","Number"]
[null,"A",{"$f":"LetterToNumber(B5)","v":1},null,null,null,null,"A"]
[null,"F",{"$f":"LetterToNumber(B6)","v":6},null,null,null,null,"F"]
[null,"T",{"$f":"LetterToNumber(B7)","v":20},null,null,null,null,"T"]
[null,"IA",{"$f":"LetterToNumber(B8)","v":235},null,null,null,null,"IA"]
[null,"TA",{"$f":"LetterToNumber(B9)","v":521},null,null,null,null,"TA"]
[null,"ABC",{"$f":"LetterToNumber(B10)","v":731},null,null,null,null,"ABC"]
[null,"XBL",{"$f":"LetterToNumber(B11)","v":16288},null,null,null,null,"XBL"]