The New PIVOTBY Function + Warnings + a Weird Thing about COUNTA

/in /by

The Excel team has released a lot of functions. PIVOTBY is really slick and helpful because it’s dynamic and doesn’t require a refresh when your underlying data changes. But there are warnings.

You’ll see PIVOTBY with COUNT, PERCENTOF and COUNTA.
You’ll see strengths and limitations.
And! Something odd about COUNTA that I never noticed until playing with PIVOTBY.

For a list of my Excel courses at LinkedIn Learning:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
My old blog: http://datascopic.net/blog-2-2