Sunday, June 6, 2021

Create a Pivot Table without Using the Pivot Table Feature (SORT & UNIQUE)

Pivot Tables are one of those great data analysis tools. But what if you wanted a simple cross tab (aka pivot table) without using the Pivot Table command in the ribbon. You could have done this before with various combinations of commands and use the CTRL+SHIFT+ENTER to create arrays. But in Office 365 there are two dynamic array functions (SORT & UNIQUE) that let you create a cross tab very easily. The UNIQUE function in it self is totally useful and I'll cover it in detail near the end of the vid.

No comments:

Post a Comment