Seems I answered my own question when I tried the array formula you suggested, with the Ctrl+Shift+Enter. Doh!

Not sure why MS decided to make a new function to do the same thing as another function. Maybe the thinking is "Different is Better". Go figure.