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
enter image description here
New contributor
Mohamed Zayed is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.