Question: are dynamic arrays available in excel?
Answer: Dynamic arrays are currently available to all Insider users on Excel for Windows and Insider Fast users on Excel for Mac. While its currently only available for testing on Windows and Mac, dynamic arrays support is coming to all platforms.