The GROUPBY() Secret You’ve Been Waiting For! - Excel Tips and Tricks If you're still here, I know you’re ready to unlock next-level Excel power—so let’s dive in! Here’s How GROUPBY() Works Like Magic: ✔ Group ONE column SUM? Easy: =GROUPBY(Region, Sales, SUM) ✔ Group MULTIPLE columns (Region Product)? Slightly trickier: =GROUPBY(HSTACK(Region, Product), Sales, SUM) ✔ Group MULTIPLE columns AND return SUM AVERAGE? 🎯 Boom: =GROUPBY(HSTACK(Region, Product), Sales, HSTACK(SUM, AVERAGE)) 💡 Pro Tip
2:10
The GROUPBY() Secret You’ve Been Waiting For! - Excel Tips and Tricks If you're still here, I know you’re ready to unlock next-level Excel power—so let’s dive in! Here’s How GROUPBY() Works Like Magic: ✔ Group ONE column SUM? Easy: =GROUPBY(Region, Sales, SUM) ✔ Group MULTIPLE columns (Region Product)? Slightly trickier: =GROUPBY(HSTACK(Region, Product), Sales, SUM) ✔ Group MULTIPLE columns AND return SUM AVERAGE? 🎯 Boom: =GROUPBY(HSTACK(Region, Product), Sales, HSTACK(SUM, AVERAGE)) 💡 Pro Tip
6.1K views2 weeks ago
TikTokexceltips247
สรุปข้อมูลด้วย GROUPBY HSTACK 😎💚 #excelsoezy #exceltips #exceltricks #howto #office
2:31
สรุปข้อมูลด้วย GROUPBY HSTACK 😎💚 #excelsoezy #exceltips #exceltricks #howto #office
1.6K views2 months ago
TikTokexcelsoezy
Dynamic Excel Magic: HSTACK & TOCOL for Non-Blank Brilliance! 🚀📊✨ Unleash the power of dynamic data arrangement! Learn how to use HSTACK and TOCOL functions in Excel to organize non-blank cells dynamically. ⚙️💡 Elevate your spreadsheet skills and share your dynamic hacks in the comments! 💬💻 #ExcelTips #DynamicFunctions #HSTACK #TOCOL #SpreadsheetSkills #DataMagic | Excel Formulas Unleashed
0:38
Dynamic Excel Magic: HSTACK & TOCOL for Non-Blank Brilliance! 🚀📊✨ Unleash the power of dynamic data arrangement! Learn how to use HSTACK and TOCOL functions in Excel to organize non-blank cells dynamically. ⚙️💡 Elevate your spreadsheet skills and share your dynamic hacks in the comments! 💬💻 #ExcelTips #DynamicFunctions #HSTACK #TOCOL #SpreadsheetSkills #DataMagic | Excel Formulas Unleashed
14.8K viewsOct 27, 2023
FacebookExcel Formulas Unleashed
Prepare Quickly Summary Report MIS | HR Example | Dynamic Array Formulas (GROUPBY, DROP, SORT, HSTACK, ARRAYTOTEXT, COUNTA) | #Excel 365 =SORT(DROP(GROUPBY(Database[EMP No]:Database[Employee Name],Database[Training],HSTACK(ARRAYTOTEXT,COUNTA),,0),1),1,1) | Excel Basement
6:16
Prepare Quickly Summary Report MIS | HR Example | Dynamic Array Formulas (GROUPBY, DROP, SORT, HSTACK, ARRAYTOTEXT, COUNTA) | #Excel 365 =SORT(DROP(GROUPBY(Database[EMP No]:Database[Employee Name],Database[Training],HSTACK(ARRAYTOTEXT,COUNTA),,0),1),1,1) | Excel Basement
674 views5 months ago
FacebookExcel Basement
HSTACK Function
HSTACK Function
1 year ago
exceljet.net
VSTACK Function
VSTACK Function
1 year ago
exceljet.net
Dynamic Excel Hacks : GROUPBY and Table Integration Made Easy
Dynamic Excel Hacks : GROUPBY and Table Integration Made Easy
2 months ago
geeky-gadgets.com
GROUPBY Function with Multiple Aggregations in #Excel 365 =GROUPBY(B4:C18,D4:D18,HSTACK(SUM,AVERAGE,COUNT)) | Excel Basement
1:00
GROUPBY Function with Multiple Aggregations in #Excel 365 =GROUPBY(B4:C18,D4:D18,HSTACK(SUM,AVERAGE,COUNT)) | Excel Basement
1.6K viewsJan 1, 2024
FacebookExcel Basement
Multiple Aggregations with GROUPBY & HSTACK / AGGREGATE Function in Microsoft #Excel Excel 365 Version =GROUPBY(,Data[Sales],HSTACK(SUM,AVERAGE,MAX,MIN)) For Older Versions of Excel =AGGREGATE({9,1,4,5},,Data[Sales]) | Excel Basement
0:28
Multiple Aggregations with GROUPBY & HSTACK / AGGREGATE Function in Microsoft #Excel Excel 365 Version =GROUPBY(,Data[Sales],HSTACK(SUM,AVERAGE,MAX,MIN)) For Older Versions of Excel =AGGREGATE({9,1,4,5},,Data[Sales]) | Excel Basement
24.5K views9 months ago
FacebookExcel Basement
Learn how to use the HSTACK function in Microsoft Excel to combine data from multiple columns horizontally — just like magic! ⚡ Perfect for students, office workers, and data analysts who want to save time and boost productivity. 📘 Formula Used: =HSTACK(A1:A3, B1:B3) 💡 Tip: Works great with VSTACK to organize your Excel sheets neatly. #Excel #MicrosoftExcel #Hstack #ExcelShorts #ExcelTips #learnexcel #short #reels | Computer Tech
0:22
Learn how to use the HSTACK function in Microsoft Excel to combine data from multiple columns horizontally — just like magic! ⚡ Perfect for students, office workers, and data analysts who want to save time and boost productivity. 📘 Formula Used: =HSTACK(A1:A3, B1:B3) 💡 Tip: Works great with VSTACK to organize your Excel sheets neatly. #Excel #MicrosoftExcel #Hstack #ExcelShorts #ExcelTips #learnexcel #short #reels | Computer Tech
2K views4 months ago
FacebookComputer Tech
GROUPBY Function with TOP N Results & Multiple Aggregations in #Excel 365 =TAKE(SORT( GROUPBY(Data[Category], Data[Revenue], HSTACK(SUM,AVERAGE,COUNT),,0), 2,-1),C4) | Excel Basement
0:56
GROUPBY Function with TOP N Results & Multiple Aggregations in #Excel 365 =TAKE(SORT( GROUPBY(Data[Category], Data[Revenue], HSTACK(SUM,AVERAGE,COUNT),,0), 2,-1),C4) | Excel Basement
40.5K viewsOct 15, 2024
FacebookExcel Basement
GROUPBY Function with Multiple Aggregations including HSTACK & VSTACK in #Excel 365 =VSTACK({"Category","Sales","",""}, GROUPBY(Data[Category],Data[Sales], HSTACK(SUM,AVERAGE,PERCENTOF))) | Excel Basement
0:54
GROUPBY Function with Multiple Aggregations including HSTACK & VSTACK in #Excel 365 =VSTACK({"Category","Sales","",""}, GROUPBY(Data[Category],Data[Sales], HSTACK(SUM,AVERAGE,PERCENTOF))) | Excel Basement
11.8K viewsSep 4, 2024
FacebookExcel Basement
Excel VSTACK and HSTACK Functions • My Online Training Hub
Excel VSTACK and HSTACK Functions • My Online Training Hub
Sep 1, 2022
myonlinetraininghub.com
GROUPBY Function with Multiple Aggregations & Chronological Order Sorting for Months in Microsoft #Excel 365 =GROUPBY(--(1&Data[Months]),Data[Sales],HSTACK(SUM,AVERAGE,COUNT)) | Excel Basement
0:30
GROUPBY Function with Multiple Aggregations & Chronological Order Sorting for Months in Microsoft #Excel 365 =GROUPBY(--(1&Data[Months]),Data[Sales],HSTACK(SUM,AVERAGE,COUNT)) | Excel Basement
30.3K viewsJul 3, 2024
FacebookExcel Basement
Get Multiple Values LOOKUP & Aggregations via GROUPBY, ARRAYTOTEXT & VSTACK Functions in #Excel 365 =VSTACK({"Names","Units Sold"}, GROUPBY(Data[Names],Data[Units Sold], ARRAYTOTEXT,,0)) =VSTACK({"Names","Units Sold",""}, GROUPBY(Data3[Names],Data3[Units Sold], HSTACK(ARRAYTOTEXT,SUM),,0)) | Excel Basement
0:53
Get Multiple Values LOOKUP & Aggregations via GROUPBY, ARRAYTOTEXT & VSTACK Functions in #Excel 365 =VSTACK({"Names","Units Sold"}, GROUPBY(Data[Names],Data[Units Sold], ARRAYTOTEXT,,0)) =VSTACK({"Names","Units Sold",""}, GROUPBY(Data3[Names],Data3[Units Sold], HSTACK(ARRAYTOTEXT,SUM),,0)) | Excel Basement
4.8K views7 months ago
FacebookExcel Basement
GROUPBY Function in Excel: The PivotTable Killer You Need to Know
3:22
GROUPBY Function in Excel: The PivotTable Killer You Need to Know
20 views2 weeks ago
YouTubeTbrands: Advanced Excel Hacks & Analysis tips
Excel VSTACK and HSTACK Functions
9:02
Excel VSTACK and HSTACK Functions
73K viewsJul 10, 2023
YouTubeTechnology for Teachers and Students
VSTACK & HSTACK function in excel!
1:18
VSTACK & HSTACK function in excel!
374 viewsAug 26, 2023
YouTubeNoteDown
How to group data in Excel [5 Methods]
16:13
How to group data in Excel [5 Methods]
5K views6 months ago
YouTubeHow to Excel
Excel PivotBy Function: 3 Powerful Examples
19:34
Excel PivotBy Function: 3 Powerful Examples
5.7K views11 months ago
YouTubeOfficeNewb.com
New Excel GROUPBY Function—Why Everyone’s Talking About It
7:50
New Excel GROUPBY Function—Why Everyone’s Talking About It
2.2K views11 months ago
YouTubeAnalytics Success
Excel VSTACK & HSTACK Tutorial: Combine Data from Multiple Sheets
5:26
Excel VSTACK & HSTACK Tutorial: Combine Data from Multiple Sheets
1.4K viewsJul 26, 2023
YouTubeTEKNISHA
How to Use Hstack Function In Excel
1:21
How to Use Hstack Function In Excel
41 views8 months ago
YouTubeMicrosoft Expert
Excel’s GROUPBY and PIVOTBY explained
12:38
Excel’s GROUPBY and PIVOTBY explained
153 views10 months ago
YouTubeCPA Australia
Group Data with =GROUPBY in Excel
0:48
Group Data with =GROUPBY in Excel
11.6K views8 months ago
YouTubeExcel With Grant
VSTACK and HSTACK function in Excel
8:39
VSTACK and HSTACK function in Excel
9.1K viewsApr 11, 2023
YouTubePK: An Excel Expert
Excel HSTACK Formula – The Ultimate Shortcut!
0:21
Excel HSTACK Formula – The Ultimate Shortcut!
3.2K viewsFeb 22, 2025
YouTubeBright Minds Hub
Combine Data From Multiple Excel Sheets Fast (VSTACK & HSTACK)
11:50
Combine Data From Multiple Excel Sheets Fast (VSTACK & HSTACK)
71.2K viewsSep 1, 2022
YouTubeMyOnlineTrainingHub
Master the New GROUPBY & PIVOTBY Functions in Excel
11:26
Master the New GROUPBY & PIVOTBY Functions in Excel
43.4K viewsMar 30, 2025
YouTubeKenji Explains
New Excel Functions 2022 VSTACK and HSTACK
0:29
New Excel Functions 2022 VSTACK and HSTACK
12.1K viewsMar 24, 2022
YouTubeMatt Brattin
See more