GROUPBY with Distinct Count & Sorting (High to Low) with Total Row at the End in #Excel 365 #shorts
Details
| Title | GROUPBY with Distinct Count & Sorting (High to Low) with Total Row at the End in #Excel 365 #shorts |
| Author | Rahim Zulfiqar Ali |
| Duration | 0:54 |
| File Format | MP3 / MP4 |
| Original URL | https://youtube.com/watch?v=rdmaZ-bcNRM |
Description
GROUPBY with Distinct Count & Sorting (High to Low) with Total Row at the End in #Excel 365 | ADVANCED LEVEL - Dynamic Array Formulas
=GROUPBY(Data[Company],Data[Employee Name],LAMBDA(groupValues,COUNTA(UNIQUE(groupValues))))
