No of People under each Manager

[Shreesurya]

Hi Experts,

Need your help to calculate number of people under each manager. Please help me the decode this complications.

[TABLE="class: grid, width: 0"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Level
[/TD]
[TD]Lead
[/TD]
[TD]Manager[/TD]
[/TR]
[TR]
[TD]Brian[/TD]
[TD]Level 1[/TD]
[TD]Alfred[/TD]
[TD]Sheldon[/TD]
[/TR]
[TR]
[TD]Erick[/TD]
[TD]Level 1[/TD]
[TD]Alfred[/TD]
[TD]Sheldon[/TD]
[/TR]
[TR]
[TD]Alfred[/TD]
[TD]Level 2[/TD]
[TD]Sheldon[/TD]
[TD]Raymond[/TD]
[/TR]
[TR]
[TD]Sheldon[/TD]
[TD]Level 3[/TD]
[TD]Raymond[/TD]
[TD]Edward [/TD]
[/TR]
[TR]
[TD]Raymond[/TD]
[TD]Level 4[/TD]
[TD]Edward [/TD]
[TD]Donald[/TD]
[/TR]
</tbody>[/TABLE]

Result I'm expect as below.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Manager
[/TD]
[TD]Level 4
[/TD]
[TD]Level 3
[/TD]
[TD]Level 2
[/TD]
[TD]Level 1[/TD]
[/TR]
[TR]
[TD]Edward [/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Raymond[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sheldon[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Donald[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

Please reach out to me if you have any further information is required to help me.

Thank you so much.
Surya Prakash R

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...nt-under-manager-post5240790.html#post5240790

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).