The New PIVOTBY Function + Warnings + a Weird Thing about COUNTA
The Excel team has released a lot of functions recently. PIVOTBY is one of them. It's 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.
#PIVOTBY
#DynamicArrays
For a list of my Excel courses at LinkedIn Learning:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guer...
My old blog: http://datascopic.net/blog-2-2