Excel Challenge: FREQUENCY OF ALPHABETS IN A STRING
In this video, I demonstrate how to extract the number of times every unique alphabet appears in a string. 2 methods are shown, the "conventional" and one using the new GROUPBY Function
Link to Excel workbook:
https://docs.google.com/spreadsheets/...
00:00 Introduction
00:15 Problem Description
02:13 Step-by-step breakdown - helper columns
05:28 Method 1 : One-cell, no helpers
09:47 Making the formula spill
11:20 Method2: Groupby function
14:17 Spilling with method 2
15:11 Closing thoughts
#Groupby #excelchallenge #excelfunctions