FILTER() is available to Microsoft 365, Excel ... what’s known as a spill range, which is the result of a dynamic array formula that returns multiple values—its output spills beyond the input ...

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