In this tutorial, we will introduce you to the fabulous SEQUENCE function in Excel along with two ‘real world’ examples of its use.
The SEQUENCE function is a dynamic array function and is only available in Excel 365, Excel 2021 and in Excel Online.
When you first see the SEQUENCE function, it is maybe not that clear how it will come in useful. So, two examples will be provided toward the end of this tutorial, and in the following video, to see some practical uses.
You can download the Excel workbook used in this tutorial to follow along.[Read more…] about SEQUENCE Function in Excel