Preview of Dynamic Arrays in Excel

March 31st 2020 Update Dynamic Arrays is now available to Office 365 users on all endpoints, with the exception of users on the Semi-Annual channel. It will be available to users in Semi-Annual (Targeted) channel starting mid April 2020.    Until now, you wrote a formula for each value you wanted …