Forum Discussion
Grouping columns
nabilmourad ... the pivot table creates the list of unique names dynamically. With hundreds of rows it might be easy to miss a name when creating the list for a formula.
I suspect that, if datasets are sufficiently small that you update them by hand rather than importing a fresh query from an external source, the modern dynamic array might be a contender.
The new functions UNIQUE and SORT are fast and reliable and they update automatically as the data is changed. The SUMIFS are somewhat more labour-intensive to create but it may only need a single instance of the formula to spill and populate the crosstab or list dynamically. To home in on a specific provider, one could use FILTER to create a separate output table rather than the traditional worksheet filter that simply hides much of the source data. Not quite as slick as slicers though.
The Pivot Table may still have the edge but it is no longer the only game in town!
PeterBartholomew1 Definitely! Dynamic Arrays will be a game changer and make many a pivot table obsolete.
However, I'm conscious of the fact that as of today Dynamic Arrays are still only available to people who run Office 365 Insider Fast, so I'm advising the solution that will work for everybody right now.