{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Contents","Introduction ADDRESS","Basic Example","Combined with INDIRECT","Address of Value","Column Letters","Named Range address"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":2,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["ADDRESS Function"]
[null,"automateexcel.com/functions/address-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction ADDRESS",null,null,null,"Excel Formulas w/Examples"]
[null,"Basic Example",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Combined with INDIRECT",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Address of Value"]
[null,"Column Letters"]
[null,"Named Range address"]
[]
[]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction ADDRESS","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ADDRESS",null,"=ADDRESS (row_num, col_num, [abs_num], [a1], [sheet])"]
[]
[null,"The Excel ADDRESS function returns the address for a cell based on a given row and column number."]
[]
[null,"ROW","COLUMN","ABS","A1","SHEET","ADDRESS","ADDRESS"]
[null,1,1,1,null,null,{"$f":"ADDRESS(B7,C7,D7)","v":"$A$1"},{"$f":"IF(_xlfn.ISFORMULA(G7),_xlfn.FORMULATEXT(G7),G7)","v":"=ADDRESS(B7,C7,D7)"}]
[null,1,1,2,null,null,{"$f":"ADDRESS(B8,C8,D8)","v":"A$1"},{"$f":"IF(_xlfn.ISFORMULA(G8),_xlfn.FORMULATEXT(G8),G8)","v":"=ADDRESS(B8,C8,D8)"}]
[null,1,1,3,null,null,"$A1","=ADDRESS(B9,C9,D9)"]
[null,1,1,4,null,null,"A1","=ADDRESS(B10,C10,D10)"]
[null,10,15,null,null,null,{"$f":"ADDRESS(B11,C11)","v":"$O$10"},"=ADDRESS(B11,C11)"]
[null,35000,26,null,null,null,{"$f":"ADDRESS(B12,C12)","v":"$Z$35000"},"=ADDRESS(B12,C12)"]
[null,1,1,1,1,"Sheet 01",{"$f":"ADDRESS(B13,C13,D13,E13,F13)","v":"'Sheet 01'!$A$1"},"=ADDRESS(B13,C13,D13,E13,F13)"]
[]
[null,"automateexcel.com/functions/address-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Basic Example","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Row",1]
["Column",4]
["Formula",{"$f":"ADDRESS(B1,B2)","v":"$D$1"}]
[]
[null,"automateexcel.com/functions/address-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Combined with INDIRECT","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Row",1,null,"Apple"]
["Column",4,null,"Banana"]
["Formula",{"$f":"INDIRECT(ADDRESS(B1,B2))","v":"Apple"},null,"Pear"]
[]
[null,"automateexcel.com/functions/address-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Address of Value","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student","Grade",null,null,"Max","Median","Min"]
["Adam",80,null,"Value",{"$f":"MAX($B$2:$B$6)","v":98},{"$f":"MEDIAN($B$2:$B$6)","v":87},{"$f":"MIN($B$2:$B$6)","v":80}]
["Charlie",85,null,"Address",{"$f":"ADDRESS(MATCH(E2,$B:$B,0),2)","v":"$B$5"},{"$f":"ADDRESS(MATCH(F2,$B:$B,0),2)","v":"$B$4"},{"$f":"ADDRESS(MATCH(G2,$B:$B,0),2)","v":"$B$2"}]
["Dan",87]
["Susan",98]
["Molly",94]
[]
[null,"automateexcel.com/functions/address-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Column Letters","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Number","Letter"]
[1,{"$f":"SUBSTITUTE(ADDRESS(1,A2,4),\"1\",\"\")","v":"A"}]
[13,{"$f":"SUBSTITUTE(ADDRESS(1,A3,4),\"1\",\"\")","v":"M"}]
[240,{"$f":"SUBSTITUTE(ADDRESS(1,A4,4),\"1\",\"\")","v":"IF"}]
[987,{"$f":"SUBSTITUTE(ADDRESS(1,A5,4),\"1\",\"\")","v":"AKY"}]
[2100,{"$f":"SUBSTITUTE(ADDRESS(1,A6,4),\"1\",\"\")","v":"CBT"}]
[]
[null,"automateexcel.com/functions/address-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Named Range address","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student","Grade",null,"Top Left",{"$f":"ADDRESS(ROW(Grades), COLUMN(Grades))","v":"$A$1"}]
["Adam",80,null,"Bottom Right",{"$f":"ADDRESS(ROWS(Grades)-ROW(Grades)+1,COLUMNS(Grades)-COLUMN(Grades)+1)","v":"$B$6"}]
["Charlie",85,null,"Full Address",{"$f":"E1 & \":\" & E2","v":"$A$1:$B$6"}]
["Dan",87]
["Susan",98]
["Molly",94]
[]
[null,"automateexcel.com/functions/address-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]