Before you use the SEQUENCE and COUNTA functions together to create this scenario, ensure the data is not formatted as an Excel table. This is because SEQUENCE is a dynamic array function that ...

How to use the FILTER() dynamic array ... the function is more flexible if you use input cells for the include argument. Figure D shows the necessary setup. We’ll use column I to create more ...

Excel's OFFSET function lets you create ... Finally, I want to create a weekly report in the orange table. This will require me to input a week number, and Excel will then generate the total ...

How to use the newish XLOOKUP() dynamic array function ... Excel used to work with dynamic arrays. Thanks to the new dynamic array feature, these types of expressions are much easier to create ...