Misrosoft is testing dynamic arrays in excel. Currently they are available for users in Office 365 Insiders Program. This seems to be very useful feature, it will allow to solve a a lot of tasks with lists, also asked on this forum, in seconds.
A preview of this feature is here.
combo
A preview of this feature is here.
combo