Comment by canistel

With _array formulae_ you can live without pivot tables, to a certain extent. They would auto-refresh, too...