News

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 ...
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 ...