GROUPBY & PERCENTOF Functions Not Work With Text Data!?!? Here Is Solution!! Excel Magic Trick 1870

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1870-1871.xlsx
Learn how to use the GROUPBY function with the eta lambda function COUNTA and PERCENTOF to create frequency distribution that works with text data. Create a count column and a % of Column Total Column with the GROUPBY Function.
ExcelLambda from YouTube supplies awesome solution!
Topics:
1. (00:00) Introduction.
2. (00:21) PivotTables vs. GROUPBY or PIVOTBY Function
3. (00:57) First attempt at using GROUPBY Function. See functions GROUPBY, HSTACK, COUNT and PERCENTOF.
4. (02:00) Why PivotTable correctly calculates % of Column Total for Text Data
5. (02:29) Algorithm for PERCENTOF Function and how it is different than a PivotTable % of Column Total Calculation.
6. (03:05) Second attempt at using GROUPBY Function. See functions GROUPBY, HSTACK, COUNT, SUM, PERCENTOF, SEQUENCE and ROWS.
7. (03:49) Why second try fails.
8. (04:13) Correct Formula to get GROUPBY and PERCENTOF to work with Text Data.
9. (05:17) Summary
10. (05:35) Closing

#excel #microsoft #excelisfun #excelcourses #excelcourse #excelfunctions #excelformula #excelfunction #365excel #office365 #office365training #exceltips #exceltutorial #exceltraining #exceltricks #excelmaster #excelmagictrick #excelmagic
#groupby #groupbyarrayfunction #pivotby #pivotbyarrayfunction #pivottable #pivot #pivot_table #sequence #rows #drop #percentage #percentage_trick #percentage_math #percentageof

excelisfunMon, February 24, 2025 2:10pm