How to use groupby and arraytotext formulas in ms excel 365 - AI driven GROUPBY formula example 1
2:09
How to use groupby and arraytotext formulas in ms excel 365 - AI driven GROUPBY formula example 1
270 viewsOct 30, 2024
YouTubeAI Tech + Excel
Groupby with ArrayToText Multiple Values and Chronological Sorting #Excel 365 | Excel Basement
0:58
Groupby with ArrayToText Multiple Values and Chronological Sorting #Excel 365 | Excel Basement
7.3K views7 months ago
FacebookExcel Basement
GROUPBY for combining text and custom functions in Excel
8:02
GROUPBY for combining text and custom functions in Excel
1.6K viewsJan 15, 2025
YouTubeDavid Benaim
GROUPBY with ARRAYTOTEXT | Get Multiple Values (Outputs) from Lookup Value in #Excel =GROUPBY(Data[City],Data[Revenue],ARRAYTOTEXT,,0) | Excel Basement
0:42
GROUPBY with ARRAYTOTEXT | Get Multiple Values (Outputs) from Lookup Value in #Excel =GROUPBY(Data[City],Data[Revenue],ARRAYTOTEXT,,0) | Excel Basement
7.4K viewsMar 28, 2025
FacebookExcel Basement
GROUPBY Function with LAMBDA! Get Multiple Values (Unique) from an Array | GAME CHANGE!!! | Microsoft #Excel =GROUPBY(Data[City],Data[Area],LAMBDA(x,ARRAYTOTEXT(SORT(UNIQUE(x)))),,0) | Excel Basement
0:30
GROUPBY Function with LAMBDA! Get Multiple Values (Unique) from an Array | GAME CHANGE!!! | Microsoft #Excel =GROUPBY(Data[City],Data[Area],LAMBDA(x,ARRAYTOTEXT(SORT(UNIQUE(x)))),,0) | Excel Basement
8.3K viewsMar 28, 2025
FacebookExcel Basement
GROUPBY with ARRAYTOTEXT & VSTACK HSTACK Function 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
GROUPBY with ARRAYTOTEXT & VSTACK HSTACK Function 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
7.5K viewsSep 7, 2024
FacebookExcel Basement
GROUP BY with LAMBDA! GAME CHANGE!!! Microsoft #Excel 365 Version | Get Multiple Values (Unique) from an Array =GROUPBY(Data[City],Data[Area],LAMBDA(x,ARRAYTOTEXT(SORT(UNIQUE(x)))),,0) As functions, GROUPBY and PIVOTBY are lightweight, fully descriptive, automatically update and can depend on the result of other calculations. They also aggregate using lambda functions which unlock new aggregation capabilities. Consider the following example where I aggregate text values. Here I make use of a lam
0:46
GROUP BY with LAMBDA! GAME CHANGE!!! Microsoft #Excel 365 Version | Get Multiple Values (Unique) from an Array =GROUPBY(Data[City],Data[Area],LAMBDA(x,ARRAYTOTEXT(SORT(UNIQUE(x)))),,0) As functions, GROUPBY and PIVOTBY are lightweight, fully descriptive, automatically update and can depend on the result of other calculations. They also aggregate using lambda functions which unlock new aggregation capabilities. Consider the following example where I aggregate text values. Here I make use of a lam
2.2K viewsNov 15, 2023
FacebookExcel Basement
2:39
How to Use the ARRAYTOTEXT Function in Microsoft Excel! Format Arrays in Text in Excel! #msexcel
741 viewsApr 29, 2024
YouTubeBrandon's Excel Tutorials
0:11
Convert Array to Text in Excel Using ARRAYTOTEXT
1.3K views6 months ago
YouTubeExcel Tutorials Hub By Prabhakar
0:14
Convert Excel Data to Text Effortlessly with ARRAYTOTEXT! 💥 #excel #excelshorts
1.7K viewsSep 30, 2024
YouTubeTech Table Tutor
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 views6 months ago
FacebookExcel Basement
10:23
ARRAYTOTEXT() Function Excel - 5 Practical Examples
23.6K viewsApr 27, 2021
YouTubeTeachExcel
3:59
How to Use the GROUPBY Function in Excel – The Definitive Guide
1.5K viewsDec 3, 2023
YouTubeExcel Bootcamp
ARRAYTOTEXT Function
5 months ago
exceljet.net
0:38
Merge Text Using ARRAYTOTEXT in Excel #excel #spreadsheetmagic #excelautomation
1K views2 months ago
YouTubeZOOMIXinfo
1:50
GROUPBY Function Explained! #excel #spreadsheetmagic#groupbyfunction
2.4K views5 months ago
YouTubeChalo Ye Bhi Seekhe
2:43
Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741
21.8K viewsJun 22, 2021
YouTubeexcelisfun
8:29
Excel Trick: GROUPBY 裏面使用 ARRAYTOTEXT | 可以超越 PIVOT TABLE 功能 |資料整理 ✅清晰 ✅簡潔
4K viewsApr 4, 2025
YouTubeKK's Menu
0:22
Excel GROUPBY Formula | Summarize Data Instantly
827 views2 months ago
YouTubeExcel by MB
0:18
Excel Array Magic: Transform Arrays to Text with Unique Brilliance! 📊✨🔗 Unlock the power of Excel's ArraytoText and Unique functions! Learn how to seamlessly convert arrays to text while maintaining uniqueness. Elevate your data manipulation skills and explore the magic of these functions in this tutorial. Watch, learn, and transform your spreadsheets like never before! 💻🌐 #ExcelTips #ArraytoText #UniqueFunction #SpreadsheetSkills #DataMagic | Excel Formulas Unleashed
8.2K viewsNov 15, 2023
FacebookExcel Formulas Unleashed
13:25
How to Use the Excel GROUPBY Function
2.6K viewsApr 18, 2025
YouTubeProlific Oaktree
3:15
How to use GroupBY Function in Excel for Data Aggregation
3.3K viewsAug 9, 2024
YouTubeCorporate Finance Institute
17:33
NEW Excel GROUPBY Function - How does it work?
15.9K viewsJan 31, 2024
YouTubeCellmates
30:37
14 Practical uses of the new GROUPBY Function
673 viewsOct 8, 2024
YouTubeIndzara - Simple and Effective Templates
0:59
Concatenate with ARRAYTOTEXT Excel Function | #shorts
1.6K viewsFeb 15, 2023
YouTubeExcelMoments
0:56
"Excel ARRAYTOTEXT Function (Part 82) | Convert Arrays to Text Easily"
140 views8 months ago
YouTubeKATKE COMPUTER TRAINING CENTER CHI…
0:34
اكتشف ميزة ARRAYTOTEXT المذهلة التي لا يعرفها أحد!
2.6K views5 months ago
YouTubeخطوات اونلاين - Online Steps
11:14
GROUPBY in Excel with dynamic drill down... Yes, it's possible.
24.9K viewsMar 20, 2025
YouTubeExcel Off The Grid
24:46
COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901
30.8K views9 months ago
YouTubeexcelisfun
15:48
GROUPBY Function The Basics and Beyond
3.5K viewsMar 12, 2024
YouTubeOfficeinstructor
See more