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.

Name	Level	Lead	Manager
Brian	Level 1	Alfred	Sheldon
Erick	Level 1	Alfred	Sheldon
Alfred	Level 2	Sheldon	Raymond
Sheldon	Level 3	Raymond	Edward
Raymond	Level 4	Edward	Donald

<tbody>
</tbody>

Result I'm expect as below.

Manager	Level 4	Level 3	Level 2	Level 1
Edward	1	1	1	2
Raymond	0	1	1	2
Sheldon	0	0	1	2
Donald	1	1	1	2

<tbody>
</tbody>

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).