© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. I. KatzUp Up and Array!https://doi.org/10.1007/978-1-4842-8966-2_4

4. The SEQUENCE Function: Made to Order

Abbott Ira Katz1  
Edgware, UK

What’s New About Sequence

Of course, Excel has long afforded us the means for unrolling a sequence of values across, or down, a spreadsheet. If you needed to enter a skein of numbers 1 through 100, we’d just enter the 1 and the 2 – thus establishing the desired interval, or step, of 1 – grab onto the AutoFill button, and pull it down 98 more rows, or across for as many columns. Moreover, if you had already entered a list of 100 names, you could post the 1 and 2 in the adjoining left column, select that tandem of values, ...

Get Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.