{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Contents","Introduction OFFSET","Basic-Row","Basic-column","OFFSET MATCH","OFFSET Range","SUM","Sum-Offset","OFFSET-N"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":[]}
["OFFSET Function"]
[null,"automateexcel.com/functions/offset-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction OFFSET",null,null,null,"Excel Formulas w/Examples"]
[null,"Basic-Row",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Basic-column",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"OFFSET MATCH"]
[null,"OFFSET Range"]
[null,"SUM"]
[null,"Sum-Offset"]
[null,"OFFSET-N"]
[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 OFFSET","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"OFFSET","=OFFSET (reference, rows, cols, [height], [width])"]
[null,"The  function OFFSET returns a reference to a range that is a specified number of "]
[null,"rows and columns from a cell or range of cells."]
[]
[null,"Quarter","FACTORY 01","FACTORY 02","FACTORY 03","FACTORY 04"]
[null,"Q 01",128686,119358,126980,146511]
[null,"Q 02",148385,131635,144923,132891]
[null,"Q 03",117526,134850,140061,107121]
[null,"Q 04",120837,133310,126206,124898]
[]
[null,"Quarter","Factory","TOTAL Value"]
[null,4,3,{"$f":"SUM(OFFSET(B6,B13,C13,1,1))","v":126206}]
[]
[null,"automateexcel.com/functions/offset-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Basic-Row","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Score","Name"]
[1,"Adam"]
[2,"Bob"]
[3,"Charlie"]
[]
[null,"automateexcel.com/functions/offset-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Basic-column","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Score","Name","Teacher"]
[1,"Adam","Mr. Smith"]
[2,"Bob","Mr. Smith"]
[3,"Charlie","Mr. Adams"]
[]
[null,"automateexcel.com/functions/offset-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"OFFSET MATCH","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["User pick","Formula","Jan","Feb","Mar","Apr"]
["Feb",{"$f":"OFFSET(B2, 0, MATCH(A2, $C$1:$F$1, 0))","v":9},13,9,7,12]
["Apr",{"$f":"OFFSET(B3, 0, MATCH(A3, $C$1:$F$1, 0))","v":10},10,10,13,10]
["Jan",{"$f":"OFFSET(B4, 0, MATCH(A4, $C$1:$F$1, 0))","v":7},7,7,13,12]
[]
[null,"automateexcel.com/functions/offset-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"OFFSET Range","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Name","Test 1","Test 2","Test 3",null,"Student"]
["Adam",84,83,80,null,"Charlie"]
["Bob",91,87,90,null,"Average score"]
["Charlie",88,86,86,null,{"$f":"AVERAGE(OFFSET(A1,MATCH(F2,A2:A5,0),1,1,3))","v":86.666666666666671}]
["Dan",96,100,91]
[]
[null,"automateexcel.com/functions/offset-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"SUM","index":6,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Client","Sales"]
["Frank",9]
["Jim",6]
["Sue",10]
["Bill",5]
["Total",{"$f":"SUM(B2:B4)","v":25}]
[]
[null,"automateexcel.com/functions/offset-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sum-Offset","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Client","Sales"]
["Frank",9]
["Jim",6]
["Sue",10]
["Bill",5]
["Total",{"$f":"SUM(B2:OFFSET(B6,-1,0))","v":30}]
[]
[null,"automateexcel.com/functions/offset-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"OFFSET-N","index":8,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Month","Sales",null,"Last N  Months",4]
["Jan",300,null,"Sum",{"$f":"SUM(OFFSET($B$1,COUNT(B:B)-$E$1+1,0,$E$1,1))","v":2150}]
["Feb",750,null,"Average",{"$f":"AVERAGE(OFFSET($B$1,COUNT(B:B)-$E$1+1,0,$E$1,1))","v":537.5}]
["Mar",500,null,"Max",{"$f":"MAX(OFFSET($B$1,COUNT(B:B)-$E$1+1,0,$E$1,1))","v":750}]
["Apr",600]
[]
[null,"automateexcel.com/functions/offset-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]