{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Example 1","Example 2","Example 3","Example 4","Syntax","Errors","Learn More"],"not_rendered":{"images":20,"external_links":1,"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"Example 1","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
["SEQUENCE function"]
["The SEQUENCE function allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. In this case we created an array 4 rows tall, by 5 columns wide."]
["We put the formula =SEQUENCE(4,5) into cell D10, and the results spilled from D10 to H13."]
["CHECK THIS OUT\nWhen you select any cell from D10:H13, Excel will automatically create a border around the entire spill area. Click here to learn more about spilled array formulas. "]
["Press CTRL+PAGE DOWN to advance to the next worksheet."]
["Give us Feedback on this tutorial"]
[]
[]
[{"$nulls":3},{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2018-01-01"},{"$f":"EOMONTH(D9,1)","v":"2018-02-28"},{"$f":"EOMONTH(E9,1)","v":"2018-03-31"},"2018-04-30","2018-05-31"]
[{"$nulls":3},{"$f":"_xlfn.SEQUENCE(4,5)","v":1},2,3,4,5]
[{"$nulls":3},6,7,8,9,10]
[{"$nulls":3},11,12,13,14,15]
[{"$nulls":3},16,17,18,19,20]

{"sheet":"Example 2","index":1,"n_rows":16,"n_cols":10,"rows_kept":16}
["SEQUENCE function"]
["In this case we created an checkerboard array 8 rows tall by 8 columns wide."]
["We put the formula =SEQUENCE(8,8) into cell C9, and the results spilled from C9 to J16."]
["EXPERT TIP\nWe used Conditional Formatting to apply the checkerboard pattern. To change it, select the array range, then go to Home > Conditional Formatting > Manage Rules."]
["Use CTRL+PAGE UP up to return to the previous worksheet, CTRL+PAGE DOWN to advance to the next sheet."]
["Give us Feedback on this tutorial"]
[]
[]
[null,null,{"$f":"_xlfn.SEQUENCE(8,8)","v":1},2,3,4,5,6,7,8]
[null,null,9,10,11,12,13,14,15,16]
[null,null,17,18,19,20,21,22,23,24]
[null,null,25,26,27,28,29,30,31,32]
[null,null,33,34,35,36,37,38,39,40]
[null,null,41,42,43,44,45,46,47,48]
[null,null,49,50,51,52,53,54,55,56]
[null,null,57,58,59,60,61,62,63,64]

{"sheet":"Example 3","index":2,"n_rows":23,"n_cols":4,"rows_kept":23}
["SEQUENCE function"]
["In this case we created a list of sequential dates."]
["We put the formula =SEQUENCE(15,TODAY()) into cell D9, and the results spilled from D9 to D23."]
["EXPERIMENT\nTo display an entire year, change the 15 to 365"]
["Use CTRL+PAGE UP up to return to the previous worksheet, CTRL+PAGE DOWN to advance to the next sheet."]
["Give us Feedback on this tutorial"]
[]
[{"$nulls":3},"Date"]
[{"$nulls":3},{"$f":"_xlfn.SEQUENCE(15,,TODAY())","v":{"$error":"#NAME?"}}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]
[{"$nulls":3},{"$error":"#NAME?"}]

{"sheet":"Example 4","index":3,"n_rows":18,"n_cols":4,"rows_kept":18}
["SEQUENCE function"]
["In this case we created list of sequential numbers in descending order."]
["We put the formula =SEQUENCE(10,,100,-10) into cell D9, and the results spilled from D9 to D18."]
["GOOD TO KNOW\nTo list the numbers in ascending order, change -10 to 10."]
["Use CTRL+PAGE UP up to return to the previous worksheet, CTRL+PAGE DOWN to advance to the next sheet."]
["Give us Feedback on this tutorial"]
[]
[{"$nulls":3},"Number"]
[{"$nulls":3},{"$f":"_xlfn.SEQUENCE(10,,100,-10)","v":100}]
[{"$nulls":3},90]
[{"$nulls":3},80]
[{"$nulls":3},70]
[{"$nulls":3},60]
[{"$nulls":3},50]
[{"$nulls":3},40]
[{"$nulls":3},30]
[{"$nulls":3},20]
[{"$nulls":3},10]

{"sheet":"Syntax","index":4,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[17,2,21,3]]}
["SEQUENCE function syntax"]
["The SEQUENCE function returns a sequence of numbers"]
["=SEQUENCE(rows,[columns],[start],[step])"]
["Scroll to cells C11:D15 for function arguments and description."]
["The SEQUENCE function will return an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER. If your supporting data is in an Excel Table, then the array will automatically resize as you add or remove data from your array range. NOTE: spilled array functions aren't supported in Excel tables.\t\n\t\n\t\n\t"]
["Use CTRL+PAGE UP up to return to the previous worksheet, CTRL+PAGE DOWN to advance to the next sheet."]
["Give us Feedback on this tutorial"]
[]
[]
[]
[null,null,"Argument","Description"]
[null,null,"rows","The number of rows to return . Required"]
[null,null,"[columns]","The number of columns to return. Optional"]
[null,null,"[start]","The first number in the sequence. Optional"]
[null,null,"[step]","The amount to increment each subsequent value in the array. Optional"]
[]
[]
[null,null,"The SEQUENCE function will return an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER. If your supporting data is in an Excel Table, then the array will automatically resize as you add or remove data from your array range. NOTE: spilled array functions aren't supported in Excel tables."]

{"sheet":"Errors","index":5,"n_rows":12,"n_cols":5,"rows_kept":12}
["SEQUENCE function errors"]
["If the SEQUENCE function is blocked, it will cause a #SPILL! error. Removing the blockage will automatically complete the formula."]
["Delete cell F12 to complete the formula in cell H9."]
["The formula in cell H9 is: =SEQUENCE(10)"]
["KEEP IN MIND\nMake sure you don't accidentally delete anything important when you're removing blockages!\n\nNOTE: spilled array functions aren't supported in Excel tables."]
["Use CTRL+PAGE UP up to return to the previous worksheet, CTRL+PAGE DOWN to advance to the next sheet."]
["Give us Feedback on this tutorial"]
[{"$nulls":4},"Units"]
[{"$nulls":4},{"$f":"_xlfn.SEQUENCE(10)","v":{"$error":"#NAME?"}}]
[]
[]
[{"$nulls":4},"BLOCKAGE"]

{"sheet":"Learn More","index":6,"n_rows":17,"n_cols":6,"rows_kept":17}
["Learn more - Scroll down to cells B11, D11, and F11 for links to other information"]
["Press CTRL+PAGE UP to return to the previous worksheet"]
["Give us Feedback on this tutorial"]
[]
[]
[]
[]
[]
[]
[null,"Related articles",null,"Other helpful information",null,"More resources"]
[null,"FILTER function",null,"Excel functions (by category)",null,"Training courses"]
[null,"RANDARRAY function",null,"Excel functions (alphabetical)",null,"Tech community"]
[null,"SINGLE function",null,"Overview of formulas in Excel",null,"Excel blog"]
[null,"SORT function",null,"How to avoid a broken formula",null,"Make a suggestion at Excel User Voice"]
[null,"SORTBY function"]
[null,"UNIQUE function"]
[null,"Spilled array behavior"]