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

{"sheet":"Example 1","index":0,"n_rows":18,"n_cols":5,"rows_kept":18}
["SINGLE function"]
["The SINGLE function, evaluates an expression using implicit intersection. The formula can return a value, range, or error. Where value is a range, SINGLE will return the value at the intersection of the row and column of the formula cell. "]
["There is data in cells C8:C18."]
["There is an output range in cells E8:E18 with the SINGLE function in cell E9."]
["The formula in E9:E18 is: =SINGLE($C$9:$C$18)."]
["CHECK THIS OUT\nTo try this formula, select cells E9:E18, enter the formula, then press Ctrl+Enter. Excel will automatically paste it in all the cells."]
["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,"Item #",null,"SINGLE"]
[null,null,{"$f":"_xlfn.SEQUENCE(10)","v":1},null,{"$f":"$C$9:$C$18","v":1}]
[null,null,2,null,2]
[null,null,3,null,3]
[null,null,4,null,4]
[null,null,5,null,5]
[null,null,6,null,6]
[null,null,7,null,7]
[null,null,8,null,8]
[null,null,9,null,9]
[null,null,10,null,10]

{"sheet":"Example 2","index":1,"n_rows":9,"n_cols":12,"rows_kept":9}
["SINGLE function"]
["This example will be used for the SINGLE formula in the next worksheet."]
["There is monthly data in cells C8:L9, with month headers in row 8, and values in row 9."]
["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,"Month",{"$f":"TEXT(DATE(YEAR(TODAY()),_xlfn.SEQUENCE(1,9),1),\"mmm\")","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,"Value",{"$f":"_xlfn.RANDARRAY(1,9)*1000","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]

{"sheet":"Example 3","index":2,"n_rows":9,"n_cols":12,"rows_kept":9}
["SINGLE function"]
["In this case, the SINGLE function references monthly values on the previous worksheet. Here we're using a single formula instead of multiple range references."]
["There is data in cells C8:L9. Row 9 has month headers, while row 9 has a SINGLE formula in cells D9:L9."]
["There is an output range in cells F8:F18 with a spilled array formula in cell F9."]
[{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#VALUE!"}}]
["TRY THIS\nSee what happens if you remove the $ signs from the formula in cell D9, then copy and paste it across."]
["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,"Month",{"$f":"TEXT(DATE(YEAR(TODAY()),_xlfn.SEQUENCE(1,9),1),\"mmm\")","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,"SINGLE",{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#NAME?"}},{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#NAME?"}},{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#NAME?"}},{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#NAME?"}},{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#NAME?"}},{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#NAME?"}},{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#NAME?"}},{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#NAME?"}},{"$f":"'Example 2'!$D$9:$L$9","v":{"$error":"#NAME?"}}]

{"sheet":"Syntax","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"merged":[[15,2,18,3]]}
["SINGLE function - Syntax"]
["The SINGLE function, evaluates an expression using implicit intersection. The formula can return a value, range, or error. Where value is a range, SINGLE will return the value at the intersection of the row and column of the formula cell. "]
["The UNIQUE function syntax is: =SINGLE(value). There are no other arguments."]
["Scroll to cells C11:D12 for function arguments and description."]
["Use Ctrl+Page Up to advance to the next worksheet, use Ctrl+Page Down to return to the previous worksheet."]
["Give us feedback on this function example"]
[]
[]
[]
[]
[null,null,"Argument","Description"]
[null,null,"Value","The value to evaluate using implicit intersection"]

{"sheet":"Errors","index":4,"n_rows":18,"n_cols":6,"rows_kept":18}
["SINGLE  function errors"]
["If you try to select an entire range to paste the SINGLE function, it can cause a #REF! error."]
["There is data in cells D8:D18, and an output area in cells F9:F19. "]
["We entered =SINGLE(, then selected D9:D18, and Excel converted the formula to =SINGLE(D9#). If you copy that down it will cause a #REF! error. "]
["Instead, select range F9:F19, enter =SINGLE(D9:D18), then press Ctrl+Enter."]
["KEEP IN MIND\nMake sure you don't accidentally delete anything important when you're removing blockages!"]
["Use Ctrl+Page Up to advance to the next worksheet, use Ctrl+Page Down to return to the previous worksheet."]
["Give us feedback on this function example",null,null,"Item #",null,"Item  #"]
[{"$nulls":3},{"$f":"_xlfn.SEQUENCE(10)","v":1},null,{"$f":"_xlfn.ANCHORARRAY(D9)","v":1}]
[{"$nulls":3},2,null,{"$f":"_xlfn.ANCHORARRAY(D10)","v":{"$error":"#REF!"}}]
[{"$nulls":3},3,null,{"$error":"#REF!"}]
[{"$nulls":3},4,null,{"$error":"#REF!"}]
[{"$nulls":3},5,null,{"$error":"#REF!"}]
[{"$nulls":3},6,null,{"$error":"#REF!"}]
[{"$nulls":3},7,null,{"$error":"#REF!"}]
[{"$nulls":3},8,null,{"$error":"#REF!"}]
[{"$nulls":3},9,null,{"$error":"#REF!"}]
[{"$nulls":3},10,null,{"$error":"#REF!"}]

{"sheet":"Learn More","index":5,"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,"SEQUENCE 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"]