Excel-如何在 M*N 关系中找到所有 M?

Excel-如何在 M*N 关系中找到所有 M?

假设我有类似以下格式的电子表格数据。我想找到为特定经理工作的员工姓名。有人能帮我解决这个问题吗?我已经能够使用数据透视表获取特定经理的员工人数。但获取他们的个人姓名却带来了问题。如果这个问题太过新手,我很抱歉。我对此还很陌生。

    Name            Department     Reporting Mgr
Neeraj Kanth        Support        Vinod Kumar Bhugari
Manoj Soni          Technical      Sunil Kumar Sharma
Amar Deep Gupta     Technical      Sukhdev Singh
Suresh Kapoor       Management     Anil Baid
Deepak Arora        Technical      Munish Gupta
Anjan Chakrabarty   Technical      Sukhdev Singh
Pravin Kumar Jha    Support        Vinod Kumar Bhugari
Shipra Shekhar      BD             Anil Baid
Vinod Parate        Technical      Anchit Sharma
B. Vamsi Krishna    Technical      Munish Gupta
Raman Kumar Raman   Technical      Sunil Kumar Sharma
Prashant Kumar      Technical      Sukhdev Singh

谢谢

相关内容