XLOOKUP () is one of several newish dynamic array functions. If you’ve ever entered an expression using Ctrl + Shift + Enter, then you’re already familiar with how Excel used to work with ...

Excel tables use named columns, allowing for flexible column placement and easy reference. Arrays, on the other hand, reference ranges by position, making them less adaptable when columns need to ...

For multi-column datasets, the process can become more complex. However, by combining dynamic array functions, you can create a formula that efficiently handles blank cells across multiple columns.

In this Excel tutorial, we’ll use a dynamic expression with RANDARRAY () at the heart of it to generate a random list of names. By including an input value, you can control the number of random ...