{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["COLUMN function","number - letter","letter - number","array","VLOOKUP","other cols","cell range","Sequence","SMALL","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":"COLUMN function","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COLUMN","Show formula",null,null,"Website:","Get Digital help"]
[null,{"$f":"COLUMN(V3)","v":22},{"$f":"_xlfn.FORMULATEXT(B3)","v":"=COLUMN(V3)"},null,null,"Webpage:","COLUMN function"]
[null,{"$f":"COLUMN(A45)","v":1},{"$f":"_xlfn.FORMULATEXT(B4)","v":"=COLUMN(A45)"}]
[null,{"$f":"COLUMN(C1)","v":3},"=COLUMN(C1)"]
[null,{"$f":"COLUMN()","v":2},"=COLUMN()"]
[null,{"$f":"COLUMN(AA48)","v":27},"=COLUMN(AA48)"]

{"sheet":"number - letter","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Number","Letter",null,"Website:","Get Digital help"]
[null,22,{"$f":"LEFT(ADDRESS(1,B3,4,1), LEN(ADDRESS(1,B3,4,1))-1)","v":"V"},null,"Webpage:","COLUMN function"]
[null,167,{"$f":"LEFT(ADDRESS(1,B4,4,1), LEN(ADDRESS(1,B4,4,1))-1)","v":"FK"}]
[null,2221,"CGK"]
[null,1,"A"]
[null,999,"ALK"]

{"sheet":"letter - number","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Letter","Number",null,"Website:","Get Digital help"]
[null,"V",{"$f":"COLUMN(INDIRECT(B3&1))","v":22},null,"Webpage:","COLUMN function"]
[null,"FK",{"$f":"COLUMN(INDIRECT(B4&1))","v":167}]
[null,"CGK",{"$f":"COLUMN(INDIRECT(B5&1))","v":2221}]
[null,"A",{"$f":"COLUMN(INDIRECT(B6&1))","v":1}]
[null,"ALK",{"$f":"COLUMN(INDIRECT(B7&1))","v":999}]

{"sheet":"array","index":3,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COLUMN function",null,null,null,null,"Website:","Get Digital help"]
[null,{"$f":"COLUMN(A1:C1)","v":1},2,3,null,null,"Webpage:","COLUMN function"]

{"sheet":"VLOOKUP","index":4,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"No","Item","Color","Qty","Price",null,null,null,"Website:","Get Digital help"]
[null,1,"QTX","Blue",5,19,null,null,null,"Webpage:","COLUMN function"]
[null,2,"EHN","Green",3,29]
[null,3,"ASD","Black",5,99]
[null,4,"KRU","Brown",87,39]
[null,5,"MIL","Purple",67,67]
[]
[null,"No","Item","Color","Qty","Price"]
[null,3,{"$f":"VLOOKUP($B10,$B$3:$F$7,COLUMN(B1))","v":"ASD"},{"$f":"VLOOKUP($B10,$B$3:$F$7,COLUMN(C1))","v":"Black"},5,99]
[null,5,{"$f":"VLOOKUP($B11,$B$3:$F$7,COLUMN(B2))","v":"MIL"},"Purple",67,67]

{"sheet":"other cols","index":5,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COLUMN function",null,null,null,null,"Website:","Get Digital help"]
[null,{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},null,null,"Webpage:","COLUMN function"]
[]
[null,"COLUMN function"]
[null,{"$f":"COLUMN(K1)","v":11},{"$f":"COLUMN(L1)","v":12},13]

{"sheet":"cell range","index":6,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COLUMN function",null,null,null,null,"Website:","Get Digital help"]
[null,{"$f":"COLUMN(F3:H3)","v":6},7,8,null,null,"Webpage:","COLUMN function"]
[null,6,7,8]
[null,6,7,8]
[null,6,7,8]

{"sheet":"Sequence","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COLUMN function",null,null,null,null,"Website:","Get Digital help"]
[null,{"$f":"COLUMN(A1)","v":1},{"$f":"COLUMN(B1)","v":2},3,null,null,"Webpage:","COLUMN function"]
[]
[null,"Odd numbers"]
[null,{"$f":"(COLUMN(A1)-1)*2+1","v":1},{"$f":"(COLUMN(B1)-1)*2+1","v":3},5]
[]
[null,"Even numbers"]
[null,{"$f":"COLUMN(A1)*2","v":2},{"$f":"COLUMN(B1)*2","v":4},6]

{"sheet":"SMALL","index":8,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Numbers",null,null,null,null,"Website:","Get Digital help"]
[null,5,null,null,null,null,"Webpage:","COLUMN function"]
[null,-2]
[null,3]
[]
[null,"SMALL function"]
[null,{"$f":"SMALL($B$3:$B$5,COLUMN(A1))","v":-2},{"$f":"SMALL($B$3:$B$5,COLUMN(B1))","v":3},5]

{"sheet":"VBA","index":9,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"COLUMN function",null,null,null,null,"Website:","Get Digital help"]
[null,2,null,null,null,null,"Webpage:","COLUMN function"]