Dynamic arrays have the potential to change the way Excel spreadsheets are created. They were released in the January 2020 wave of updates to the Office 365 subscription version. Note: currently you will only have this new function if you have Office subscription version and the Monthly update channel and you have updated Excel recently. … Continue reading New Dynamic Array Function SEQUENCE