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