LAMBDA: The ultimate Excel worksheet function
29:05
LAMBDA: The ultimate Excel worksheet function
Jan 25, 2021
MicrosoftAlexis Hagen
LAMBDA Function
LAMBDA Function
Oct 26, 2022
exceljet.net
How to Use GROUPBY in Excel (Dynamic Array Explained) (Tip 33) | IACT International Academy of Computer Training
How to Use GROUPBY in Excel (Dynamic Array Explained) (Tip 33) | IACT International Academy of Computer Training
1.2K views1 month ago
linkedin.com
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
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
Dynamic Excel Hacks : GROUPBY and Table Integration Made Easy
Dynamic Excel Hacks : GROUPBY and Table Integration Made Easy
2 months ago
geeky-gadgets.com
Connect Slicers with GROUPBY or PIVOTBY Function in Microsoft #Excel 365 | Useful Tips for Dynamic Modern Excel Dashboards | GROUPBY, LAMBDA, SUBTOTAL, UNIQUE, FILTER, SLICERS, VISUAL | #DashboardReporting #Analytics =GROUPBY(Data[Salesperson],Data[Revenue],SUM,0,0,,BYROW(Data[Category],LAMBDA(r,SUBTOTAL(3,r)))) Dynamic Chart Title: ="Revenue based on Category: "&TEXTJOIN(", ",TRUE,UNIQUE(FILTER(Data[Category],SUBTOTAL(103,OFFSET(Data[Category],ROW(Data[Category])-MIN(ROW(Data[Category])),,1))))
19:07
Connect Slicers with GROUPBY or PIVOTBY Function in Microsoft #Excel 365 | Useful Tips for Dynamic Modern Excel Dashboards | GROUPBY, LAMBDA, SUBTOTAL, UNIQUE, FILTER, SLICERS, VISUAL | #DashboardReporting #Analytics =GROUPBY(Data[Salesperson],Data[Revenue],SUM,0,0,,BYROW(Data[Category],LAMBDA(r,SUBTOTAL(3,r)))) Dynamic Chart Title: ="Revenue based on Category: "&TEXTJOIN(", ",TRUE,UNIQUE(FILTER(Data[Category],SUBTOTAL(103,OFFSET(Data[Category],ROW(Data[Category])-MIN(ROW(Data[Category])),,1))))
769 viewsMar 5, 2024
FacebookExcel Basement
COUNTIFS with multiple criteria and OR logic
May 12, 2024
exceljet.net
Use GROUPBY to aggregate data - Microsoft Excel Video Tutorial | LinkedIn Learning, formerly Lynda.com
Apr 10, 2025
linkedin.com
0:41
How to use the GroupBy function in Excel to group data! #excel #spreadsheet s#dataanlysis heet
38.9K views2 months ago
YouTubeEasily Excel
8:35
Excel LAMBDA Function
1.9M viewsJan 4, 2021
YouTubeSele Training
16:02
Excel LAMBDA - HOW & WHEN you Should use it
540.4K viewsDec 12, 2020
YouTubeLeila Gharani
14:10
Excel LAMBDA Function: How & When to Use It (Beginner-Friendly)
75.6K viewsFeb 24, 2021
YouTubeMyOnlineTrainingHub
8:25
When should I use a "groupby" in pandas?
250.1K viewsMay 19, 2016
YouTubeData School
5:26
LAMBDA Excel Function. LET & LAMBDA together to make Single Cell Reports. Excel Magic Trick 1706
57.7K viewsDec 4, 2020
YouTubeexcelisfun
6:57
How to use groupby() to group categories in a pandas DataFrame
140.3K viewsNov 2, 2020
YouTubeChart Explorers
37:12
Advanced Use of groupby(), aggregate, filter, transform, apply - Beginner Python Pandas Tutorial #5
46K viewsMay 26, 2020
YouTubeStrataScratch
2:12
Efficiently Using groupby in Pandas to Create Multiple Excel Sheets
5 views10 months ago
YouTubevlogize
3:26
GROUPBY Function in Excel
11.2K viewsFeb 1, 2024
YouTubeSpreadsheet Power
0:51
How to Use GROUPBY in Excel
5.7K views11 months ago
YouTubeExcel With Grant
0:57
How to Use GROUPBY in Excel
2.5K views8 months ago
YouTubeExcel With Grant
6:16
Use Excel MAP and LAMBDA Function to Group Values
1.1K viewsOct 30, 2024
YouTubeFaraz Shaikh
6:03
Excel VStack with Filter
11.4K viewsOct 16, 2022
YouTubeThe Excel Cave
5:34
Groupby Function Tutorial in Excel
225 views9 months ago
YouTubeOffice Productivity Hub
9:31
Exploring the GROUPBY Function in Excel
1.7K viewsFeb 9, 2024
YouTubeChris Menard
13:25
How to Use the Excel GROUPBY Function
2.3K views1 year ago
YouTubeProlific Oaktree
18:32
LAMBDA Function in Excel with Example
7.2K viewsDec 19, 2022
YouTubePK: An Excel Expert
12:59
Pandas Part 11- The Groupby() function
56.1K viewsOct 16, 2019
YouTubeCampusX
14:00
Excel MAP, BYROW, BYCOL Functions - LAMBDA Array Formulas in Excel & Google Sheets
31K viewsNov 24, 2021
YouTubeLearn Google Sheets & Excel Spreadsheets
0:48
Group Data with =GROUPBY in Excel
11.6K views8 months ago
YouTubeExcel With Grant
See more