I have excel sheet with 3 coulmns, Main group, Sub group, Sub sub group.
I have another excel table with list of main groups, in next coulmn i want to count for each main group, how many sub groups are there in.
Main Group Sub Groups Main Group Count of sub groups
A M1 A 2
A M1 B 1
A M2 C 3
B U1 D 1
B U1
B U1
C L3
C L4
C L5
D L6