Dynamic arrays as filter

[glfiedler]

Greetings,
I am trying to learn about the new concepts of dynamic arrays and the spill feature in the latest Excel. The dog is never too old to learn!
Let us say I have a named range, A1:A15, called "myNums".
This range contains positive and negative numbers.
My task is to create a list, starting in B1, containing the negative values.
I could do this very simply with a few lines of VBA code. But that is not the point. I understand this example task is trivial.
What formula should I put in cell B1 so the list of negative values would simply spill down?

 

[Fluff]

How about
=filter(A1:A15,A1:A15<0)

 

[glfiedler]

How about
=filter(A1:A15,A1:A15<0)

Fluff,
That is exactly right! I was not aware of the "filter" command.
A Microsoft web page ("Excel functions that return ranges or arrays") does not list "filter". Oh well, they didn't claim the list was all-inclusive.
Thank you very much. Stay healthy.

 

[Fluff]

You're welcome & thanks for the feedback.