When entering the functions, if you use the selection method to insert references, you will see Excel’s Table structure referencing at work instead of the actual range (array) references that I use.

The array form of the LOOKUP function is useful for large datasets organized in a rectangular range with multiple rows or columns. It searches for a value in the first row (for horizontally ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel. ... In addition, if your data set is in a Table, the array adapts as you add and remove data, ...

TL;DR Key Takeaways : Dynamically inserting blank rows in Excel improves data readability, making it easier to interpret large datasets during sorting, filtering, or grouping.