Blog Post

Excel Blog

4 MIN READ

Excel Dynamic Array Improvements

Microsoft

Feb 20, 2019

Since announcing dynamic arrays, we’ve received an overwhelmingly positive response from the community. Being a fundamental change to the way formulas work, we wanted to take some time to gather and ...

Updated Feb 21, 2019

Version 4.0

Microsoft

Joined September 06, 2016

View Profile

Excel Blog

Subscribe to the Excel Blog to get the latest product announcements and updates

SergeiBaklan

Diamond Contributor

Jul 29, 2019

PeterBartholomew1 , Ed Hansberry

That returns two separate spills, however they are synced and dynamic. For 2D spill it could be like

=IF(SEQUENCE(1,2)=1,UNIQUE(SampleData[Item]),SUMIFS(SampleData[Sales],SampleData[Item],UNIQUE(SampleData[Item])))